/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 vote303 views1 answer
Linux upload database to mysql
SQL
0 vote213 views1 answer
WHERE not regex in SQL
SQL
0 vote204 views2 answers
Replace null with 0 in sql
SQL
0 vote204 views1 answer
Sql remove last 2 digit
SQL
0 vote186 views1 answer
Oracle list index on table
SQL
0 vote201 views3 answers
Sql server import json
SQL
-1 vote190 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote217 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote222 views1 answer
Sql query inline if
SQL
2 votes276 views3 answers
3 days back in sql server
SQL

Share