/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

8 votes354 views4 answers
Reset SQL auto increment
SQL
1 vote338 views1 answer
Right outer vs left outer join
SQL
6 votes319 views1 answer
Update left join mysql
SQL
3 votes343 views5 answers
Foreign keys
SQL
0 vote311 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote347 views1 answer
Myql find duplicates
SQL
1 vote342 views1 answer
Mysql how to truncate table with foreign keys
SQL
5 votes329 views1 answer
How to check nls format in oracle
SQL
1 vote357 views1 answer
Psql view enum values
SQL
0 vote320 views1 answer
Get who is hired in january in sql
SQL

Share