/SQL/Postgre sql create table

Postgre sql create table

Postgre sql create table

CREATE TABLE cities (
    city_id serial PRIMARY KEY,
    city_name VARCHAR (255) NOT NULL,
    population INT NOT NULL CHECK (population >= 0)
);

2

Source: postgresqltutorial.com

Postgresql create table as select

CREATE TABLE films_recent AS
  SELECT * FROM films WHERE date_prod >= '2002-01-01';

2

Source: postgresql.org

Similar codes

2 votes110 views1 answer
Update trigger
SQL
6 votes114 views2 answers
Stored procedure to delete data from table in mysql
SQL
8 votes116 views2 answers
Select table column name in sql
SQL
20 votes112 views4 answers
Reset auto increment in MySQL
SQL
0 vote139 views1 answer
Hour differeence in mysql
SQL
12 votes121 views6 answers
Between in sql
SQL
0 vote79 views1 answer
Check if has alpha characters sql
SQL
0 vote116 views1 answer
Mysql user set plugin
SQL
0 vote123 views1 answer
Time in sql server
SQL
0 vote121 views1 answer
Python connect to mysql in settings.py
SQL

Share