/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 vote332 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
5 votes325 views1 answer
Oracle asynchronous query
SQL
2 votes330 views2 answers
How to view created temporary tables in mysql
SQL
2 votes357 views3 answers
Postgres create view
SQL
0 vote344 views1 answer
Leftjoin in sql
SQL
0 vote342 views1 answer
Mysql grouping functions
SQL
0 vote360 views2 answers
Sql query inner join 3 tables
SQL
0 vote332 views1 answer
Sum values by month mariadb
SQL
2 votes342 views1 answer
Oracle apex list connected users
SQL
5 votes357 views2 answers
Postgresql add not null constraint
SQL

Share