/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 vote166 views1 answer
Using distinct and count together in sql
SQL
0 vote185 views1 answer
Oracle plsql sleep
SQL
10 votes172 views2 answers
Select nextval from sequence oracle
SQL
0 vote149 views2 answers
Connect to mysql server mac terminal
SQL
4 votes175 views1 answer
How to drop a database in sql server when it is in use
SQL
7 votes145 views3 answers
Sql fill table with info from anothe rtable
SQL
4 votes192 views2 answers
Mysql alter table set column unique
SQL
0 vote149 views1 answer
Mysql query with sql to get the next row
SQL
10 votes152 views3 answers
Sql select between two dates
SQL
1 vote159 views1 answer
Increase date by one day in sql oracle
SQL

Share