/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

5 votes142 views1 answer
Oracle nls instance
SQL
0 vote117 views1 answer
Lister les index d'une table oracle
SQL
5 votes132 views1 answer
Sql check if date is between 2 dates
SQL
2 votes170 views1 answer
Search query in mysql
SQL
18 votes133 views6 answers
Creating table in MySQL
SQL
8 votes127 views3 answers
Mysql alter table add index
SQL
0 vote142 views1 answer
Create view in sql server that contain multiple select statements
SQL
19 votes131 views2 answers
Mysql add column after another
SQL
1 vote155 views2 answers
Mysql extract number from string
SQL
0 vote153 views1 answer
Mysql conf.d exampel
SQL

Share