/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

14 votes199 views2 answers
Oracle export trigger ddl
SQL
0 vote190 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote208 views1 answer
Postgres change the name of schema
SQL
0 vote205 views1 answer
Sql select random procentage from rows
SQL
0 vote143 views1 answer
How to set field to null in sql
SQL
0 vote196 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote182 views1 answer
Psql check if value in array
SQL
0 vote223 views1 answer
Sqlite unique multiple columns
SQL
11 votes367 views4 answers
Round in sql
SQL
2 votes175 views1 answer
Ifnull postgres
SQL

Share