/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 vote171 views1 answer
Oracle add proxy
SQL
2 votes177 views1 answer
Columns Present in a table
SQL
1 vote171 views2 answers
Mysql extract month
SQL
0 vote173 views1 answer
Incorrect string value: mysql
SQL
0 vote195 views1 answer
Group by 15 minute interval sql server
SQL
0 vote191 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote195 views2 answers
Sql auto update dupdated_at
SQL
1 vote152 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote175 views2 answers
Sql server Insert Into table
SQL
0 vote157 views1 answer
Mysql events not work
SQL

Share