Question

How to create table with primary key and other columns in PostgreSQL

Answer 1

CREATE TABLE public."YourTableName"
(
    "ID" bigserial NOT NULL,
    "FirstName" character varying(50),
    "LastName" character varying(50),
    PRIMARY KEY ("ID")
);

ALTER TABLE public."YourTableName"
    OWNER to postgres;

 

70+ SQL courses for beginners and professionals