/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 vote319 views1 answer
Difference between min and max date sql
SQL
0 vote297 views1 answer
Mysql jdbc timezone
SQL
0 vote287 views1 answer
How to count with except in psql
SQL
0 vote273 views1 answer
Duplicate foreign key constraint name
SQL
1 vote289 views1 answer
Sql injection
SQL
1 vote327 views1 answer
Sql check roles
SQL
0 vote323 views2 answers
Mysql where in maintain order group_concat
SQL
5 votes349 views1 answer
Oracle drop index if exists
SQL
11 votes334 views2 answers
Having clause in sql
SQL
0 vote295 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL

Share