/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 vote161 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote154 views1 answer
T-sql check if data exists
SQL
1 vote146 views1 answer
Sql insert for each distinct value
SQL
0 vote164 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote152 views1 answer
SQL loop with cursor
SQL
0 vote151 views1 answer
Insufficient memory to excute the sql query
SQL
1 vote154 views1 answer
Mysql how to reset primary key
SQL
0 vote156 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
2 votes161 views1 answer
Oracle convert run_duration to number
SQL
0 vote162 views2 answers
Temp tables in sql server
SQL

Share