/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 vote137 views1 answer
Mysql identified by syntax error
SQL
-1 vote158 views1 answer
How to Activate the database
SQL
-1 vote93 views2 answers
On delete set default sql server
SQL
0 vote160 views1 answer
How to to get time in sql
SQL
0 vote157 views2 answers
Collation in sql
SQL
0 vote138 views5 answers
Linq cheat sheet
SQL
0 vote127 views2 answers
Postgresql create role
SQL
0 vote145 views1 answer
Postgresql if else endif
SQL
0 vote136 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote148 views1 answer
Distance calculator from lat long sql query
SQL

Share