/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 votes202 views1 answer
Postgresql add enum value
SQL
4 votes193 views1 answer
Oracle error compilation line
SQL
0 vote191 views1 answer
How to remove default in mysql
SQL
0 vote197 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote209 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote193 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote213 views1 answer
Alter table add check constraint oracle
SQL
-1 vote206 views3 answers
Create temp table in sql
SQL
0 vote207 views1 answer
Sql period overlap
SQL
1 vote234 views1 answer
UseSqlServer no definition
SQL

Share