/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

11 votes236 views1 answer
Ddl materialized view
SQL
5 votes226 views1 answer
Oracle asynchronous query
SQL
8 votes273 views6 answers
Insert command in sql
SQL
0 vote242 views1 answer
Flask sqlalchemy session delete
SQL
0 vote243 views2 answers
Search stored procedures
SQL
1 vote255 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
13 votes247 views2 answers
Get tables in database sql
SQL
9 votes257 views6 answers
Oracle substring
SQL
5 votes241 views1 answer
Find table from column name in sql
SQL
8 votes272 views2 answers
Update sql server from another table
SQL

Share