/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

3 votes358 views2 answers
Oracle apex charging debug
SQL
0 vote363 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote365 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote354 views1 answer
Sql count total by foreign key
SQL
0 vote324 views2 answers
Avg() sql
SQL
8 votes307 views8 answers
Second highest salary in mysql
SQL
1 vote347 views2 answers
Oracle list partitioned tables
SQL
3 votes357 views3 answers
Start postgresql ubuntu
SQL
0 vote339 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
22 votes381 views4 answers
Mysql date_format
SQL

Share