/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 vote122 views3 answers
Run sql command line
SQL
0 vote100 views1 answer
Mysql cdn link
SQL
0 vote95 views1 answer
Output to file mysql
SQL
0 vote105 views1 answer
Select from column mysql
SQL
6 votes100 views1 answer
Wordpress change user password sql
SQL
0 vote106 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote101 views1 answer
Mysql group rows with same value
SQL
2 votes104 views1 answer
Postgresql add entry to table
SQL
3 votes151 views6 answers
Jwt laravel
SQL
0 vote96 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL

Share