Answers for "postgressql create table in a specific database"

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)
);

Posted by: Guest on June-16-2021

postgresql create table as select

CREATE TABLE films_recent AS
  SELECT * FROM films WHERE date_prod >= '2002-01-01';

Posted by: Guest on November-27-2020

Code answers related to "postgressql create table in a specific database"