/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

1 vote151 views1 answer
Sql how to duplicate a table
SQL
0 vote154 views1 answer
Power query datetime to date
SQL
0 vote129 views0 answer
SQL
11 votes104 views1 answer
Reset identity sql server
SQL
1 vote148 views1 answer
Postgresql convert text to float
SQL
-2 votes155 views2 answers
Sqlserver docker
SQL
2 votes158 views2 answers
Postgresql search all tables for column name
SQL
3 votes164 views1 answer
Oracle apex message quit website
SQL
4 votes182 views2 answers
Oracle unliock account
SQL
0 vote163 views1 answer
Enable sql server full text indexing
SQL

Share