/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 votes270 views1 answer
Import database in mysql command line xampp
SQL
1 vote303 views1 answer
Postgresql not in
SQL
1 vote313 views2 answers
Procedure syntax
SQL
1 vote317 views2 answers
Postgresql check privileges on schema
SQL
3 votes289 views2 answers
Mysql create timestamp column
SQL
0 vote286 views1 answer
Postgresql heritage
SQL
39 votes351 views4 answers
Select duplicates in sql
SQL
0 vote260 views1 answer
Postgresql import data from csv
SQL
2 votes296 views1 answer
Column names in oracle sql
SQL
0 vote271 views1 answer
Add plugins to mysql workbench
SQL

Share