/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
Nullif postgresql
SQL
0 vote264 views5 answers
Select concat alter table mysql
SQL
1 vote243 views1 answer
Sql drop with dependencies
SQL
0 vote279 views2 answers
Plpgsql
SQL
0 vote268 views1 answer
Apex for oracle 11g
SQL
59 votes416 views6 answers
Alter table sql
SQL
2 votes299 views2 answers
Null column to 0 in mysql
SQL
1 vote277 views2 answers
Postgres select from last 3 months
SQL
0 vote301 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote275 views1 answer
PGSQL dynamic table name
SQL

Share