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

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s