pg_partition_1.sql

-- Create the master table tablename_with_partition:
-- You should use the same exact schema as the one from the non partitioned table.
CREATE TABLE tablename_with_partition
(
  id integer NOT NULL DEFAULT nextval('tablename'::regclass),
  "name" character varying(150) NOT NULL,
  description text NOT NULL,
  period character varying(10) NOT NULL
  CONSTRAINT tablename_with_partition_pkey PRIMARY KEY (id)
) WITH ( OIDS=FALSE);