/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

0 vote299 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote301 views1 answer
Sql server whoami
SQL
5 votes282 views1 answer
Mongodb vs
SQL
0 vote338 views1 answer
How to get one year old query from plan cache
SQL
0 vote313 views1 answer
Psql select * from table
SQL
0 vote336 views2 answers
How to add CHECK constraint to a column in postgres
SQL
8 votes322 views3 answers
Postgres connection string
SQL
0 vote323 views1 answer
Mysql in clausule string array
SQL
0 vote327 views1 answer
Delete duplicate rows
SQL
0 vote350 views2 answers
Insert data mysql with cmd
SQL

Share