/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

2 votes178 views1 answer
Mysql virtual column
SQL
1 vote188 views2 answers
Group_concat limit mysql
SQL
0 vote187 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote170 views1 answer
Mysql two joins
SQL
0 vote157 views1 answer
SQL server select to get sum of hours
SQL
0 vote177 views1 answer
Psql store procedure-return multiple table values
SQL
1 vote199 views1 answer
Add multiple row table pl sql
SQL
5 votes197 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote198 views2 answers
How to prevent sql injection in java
SQL
0 vote178 views1 answer
Postgress append string in select
SQL

Share