/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

1 vote288 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote289 views1 answer
Error code 1292 mysql workbench
SQL
0 vote283 views1 answer
Null column as zero in mysql
SQL
36 votes304 views6 answers
Delete from where sql
SQL
5 votes271 views1 answer
Ignore duplicate rows in sqlite
SQL
3 votes292 views1 answer
Oracle sleep
SQL
0 vote290 views1 answer
Call scalar valued function sql
SQL
0 vote265 views3 answers
Drop multiple columns in sql
SQL
0 vote269 views1 answer
Alter table name including schema
SQL
0 vote309 views1 answer
What logs are available on RDS MySQL?
SQL

Share