/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 vote324 views1 answer
Select even number id data from table
SQL
1 vote334 views1 answer
Mysql not supported auth mode
SQL
0 vote336 views1 answer
Mysql backup certain tables workbench
SQL
5 votes354 views4 answers
Traduction
SQL
0 vote328 views1 answer
Difference between db.query and db.execute
SQL
0 vote373 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote333 views1 answer
Const pool = mysql.createpool()
SQL
0 vote395 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote335 views1 answer
Python list from sql
SQL
-1 vote322 views1 answer
Su: Authentication failure mysql
SQL

Share