/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 vote139 views1 answer
Remove default constraint sql server
SQL
2 votes166 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote134 views1 answer
Possgress drop if exists view
SQL
1 vote136 views1 answer
Mysql get last insert id
SQL
4 votes191 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote275 views1 answer
Oracle convert int to date
SQL
3 votes145 views1 answer
Laravel database Using Named Bindings
SQL
0 vote142 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote186 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
10 votes135 views3 answers
Sql limit results
SQL

Share