/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 vote231 views1 answer
Mariadb cast null to 0
SQL
25 votes218 views6 answers
Sql update query
SQL
0 vote230 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
2 votes232 views1 answer
Postgresql update sequence next value
SQL
3 votes246 views5 answers
Sql select
SQL
16 votes225 views5 answers
Select last row in sql
SQL
0 vote221 views1 answer
Postgres create extension if not exists
SQL
0 vote213 views1 answer
Sql server pivot rows to columns
SQL
18 votes214 views3 answers
Mysql add column with default value
SQL
0 vote218 views1 answer
Turnicate in mysql
SQL

Share