/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 vote97 views1 answer
Postgresql newline character
SQL
1 vote101 views1 answer
Create sample data postgresql
SQL
1 vote99 views1 answer
Deleting database in sql
SQL
24 votes105 views5 answers
List mysql users
SQL
-1 vote105 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote99 views2 answers
Update all columns in one update
SQL
0 vote117 views1 answer
Sql commands in android
SQL
2 votes95 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
1 vote102 views2 answers
Oracle 18c xe ORA-65096
SQL
13 votes105 views1 answer
Fetch first 5 rows in oracle sql developer
SQL

Share