/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

-1 vote171 views1 answer
Plsql while
SQL
26 votes436 views6 answers
Modify column name in sql
SQL
10 votes181 views4 answers
Primary key in sql
SQL
1 vote187 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
3 votes193 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote243 views1 answer
Mysql trigger to delete old data
SQL
2 votes191 views3 answers
Sql truncate table
SQL
0 vote201 views1 answer
Select into table variable
SQL
0 vote210 views1 answer
Repeatable read trong sql server
SQL
2 votes169 views2 answers
Get all columns from table sql
SQL

Share