/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 vote146 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote174 views1 answer
Firebase sql
SQL
5 votes186 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote194 views1 answer
Except in sql alchemy
SQL
0 vote174 views4 answers
Mysql desactivar trigger
SQL
0 vote240 views1 answer
Drop all data from tables
SQL
0 vote307 views2 answers
Mysql insert rows to another database
SQL
0 vote174 views1 answer
Postgres float to int
SQL
1 vote189 views2 answers
Oracle create synonym
SQL
10 votes280 views2 answers
Doublon sql
SQL

Share