First Time with PostgreSQL – Creating Table


CREATE TABLE “public”.”product”
(
product_id integer NOT NULL,
product_name character varying,
supplier_name character varying,
unit_price integer
)

ALTER TABLE “public”.”product” ADD UNIQUE (“product_id”);
ALTER TABLE “public”.”product” ADD PRIMARY KEY (“product_id”);

 

source:

http://blog.enricostahn.com/2010/06/11/postgresql-add-primary-key-to-an-existing-table.html