/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

24 votes306 views6 answers
Sql change table name
SQL
0 vote245 views1 answer
What is the essence of SQL?
SQL
0 vote329 views1 answer
TSQL Find csv file in folder
SQL
0 vote249 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote289 views1 answer
Mysql get hour from datetime
SQL
0 vote249 views1 answer
Postgresql add not null and not empty constraint
SQL
5 votes253 views1 answer
Oracle ora-00054 causes
SQL
0 vote263 views1 answer
Sql create text column limited values
SQL
0 vote285 views1 answer
How to get one year old query from plan cache
SQL
1 vote268 views1 answer
Sql current timestamp
SQL

Share