/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

6 votes190 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote223 views1 answer
SQL check if record exist
SQL
0 vote193 views1 answer
Monthly Birthday SQL Query
SQL
24 votes191 views4 answers
How to add column sql
SQL
0 vote198 views1 answer
How change the field place in mysql
SQL
0 vote216 views1 answer
Check if mysql db is used
SQL
0 vote213 views1 answer
Sql to excel pgadmin
SQL
2 votes217 views3 answers
Sql truncate table
SQL
0 vote186 views1 answer
Soql last week
SQL
4 votes195 views1 answer
Mysql copy table with new name
SQL

Share