PRIMARY KEY POSTGRESQL

Buat Primary key in postgresSQL

CREATE SEQUENCE rank_id_seq;

CREATE TABLE t_stock_map
(
  t_stock_map_id integer NOT NULL default nextval('rank_id_seq'),
  t_product_id character varying(32) NOT NULL,
  t_attributesetinstance_id character varying(32),
  CONSTRAINT m_stock_map_id PRIMARY KEY (t_stock_map_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE t_stock_map OWNER TO postgres;