/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 vote110 views1 answer
Oracle flush Shared Pool
SQL
0 vote54 views1 answer
Sql injection mitigation
SQL
0 vote105 views1 answer
Db format in quotation
SQL
0 vote121 views1 answer
Delete a temporary table mysql
SQL
2 votes99 views1 answer
Mysql set value as null
SQL
-1 vote101 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
8 votes174 views1 answer
Oracle search code in packages
SQL
0 vote104 views2 answers
Generate sql trigger through ef migration
SQL
1 vote104 views1 answer
Simple project for database
SQL
0 vote103 views2 answers
Cascade syntax in sql
SQL

Share