CREATE TABLE myaddress."names" ( id serial NOT NULL, firstname varchar(50) NOT NULL, lastname varchar(100) NOT NULL, email varchar(128) NOT NULL, CONSTRAINT id PRIMARY KEY (id) ) WITHOUT OIDS; ALTER TABLE myaddress."names" OWNER TO myaddress;