/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 vote124 views1 answer
Sql create text column limited values
SQL
0 vote116 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
3 votes135 views1 answer
Oracle user privileges
SQL
1 vote125 views1 answer
Oracle user last connected
SQL
0 vote127 views1 answer
Pl sql disable trigger
SQL
1 vote130 views1 answer
Show per page table in xampp
SQL
0 vote133 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote133 views1 answer
Oracle c# multiple update sql
SQL
37 votes124 views3 answers
Postgresql insert column
SQL
0 vote116 views1 answer
Mysql change default collation
SQL

Share