/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 vote336 views1 answer
What is the use of index in mysql table
SQL
0 vote351 views1 answer
Selecting all columns from table sql database
SQL
0 vote383 views1 answer
Get total and distict row diff in sql
SQL
0 vote364 views1 answer
Last date for each user sql
SQL
0 vote337 views1 answer
Can we rollback deleted data in sql
SQL
1 vote339 views1 answer
Create table tablename as select * from tablename
SQL
0 vote367 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
2 votes340 views1 answer
Brew start postgres manual
SQL
0 vote348 views1 answer
UNION ALL LEFT JOIN
SQL
15 votes341 views6 answers
Psql
SQL

Share