/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 vote140 views1 answer
Sql server udf performance
SQL
1 vote172 views4 answers
How to check table in postgresql from terminal
SQL
0 vote180 views1 answer
Convert rows into columns in oracle
SQL
4 votes140 views3 answers
Sql find second highest salary employee
SQL
1 vote158 views1 answer
Oracle create index if not exists
SQL
11 votes178 views2 answers
Import sql file laravel cmd
SQL
1 vote142 views1 answer
Get last week data in mysql
SQL
0 vote157 views1 answer
Psql check if sql script is valid
SQL
1 vote254 views1 answer
Mysql data from file
SQL
0 vote136 views1 answer
Mssql current date
SQL

Share