/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

1 vote243 views1 answer
Postgresql not in
SQL
1 vote225 views1 answer
Ora-01950 no privileges on tablespace
SQL
3 votes234 views1 answer
Fk in insert mysql
SQL
0 vote230 views1 answer
Postgresql print variable
SQL
0 vote248 views1 answer
Mysql where sum > 0
SQL
13 votes226 views6 answers
Restart postgresql
SQL
0 vote249 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote236 views1 answer
Primary key multiple colums
SQL
13 votes245 views4 answers
Mysql remove foreign key constraint
SQL
1 vote233 views1 answer
Show structure of table in sql
SQL

Share