/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 vote246 views1 answer
Mysql show foreign keys column
SQL
5 votes270 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote199 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote243 views1 answer
How to check rollback status in oracle
SQL
0 vote194 views1 answer
Low level operator in dbms
SQL
0 vote224 views1 answer
Oracle date summer time
SQL
16 votes201 views2 answers
Add column if not exists mysql
SQL
0 vote234 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
8 votes186 views5 answers
Grant permission in postgres
SQL
5 votes253 views2 answers
Mysql where in array
SQL

Share