/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 votes357 views1 answer
Pandas to sql index
SQL
0 vote365 views1 answer
Oracle temporary table
SQL
0 vote389 views1 answer
Postgresql stored procedure update table values
SQL
1 vote372 views1 answer
Oracle undo usage per session
SQL
0 vote357 views1 answer
Restart sql server command line linux
SQL
3 votes346 views1 answer
Oracle wait
SQL
3 votes465 views1 answer
Oracle nextval insert
SQL
0 vote333 views1 answer
Hangfire clean script
SQL
1 vote404 views1 answer
How to see logical reads in sql server
SQL
1 vote356 views1 answer
Show table status command in mysql
SQL

Share