/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 vote111 views1 answer
Online sql testing tool
SQL
10 votes129 views2 answers
What is database
SQL
1 vote361 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote117 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
6 votes149 views1 answer
How to get the size of the database in postgresql
SQL
0 vote112 views1 answer
Tsql delete all rows
SQL
0 vote144 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote111 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote125 views2 answers
Logical operators in sql
SQL
0 vote129 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL

Share