> I need many tables of type "id" and "name", see below: > / CREATE TABLE id_names ( > id smallint CONSTRAINT the_id PRIMARY KEY NOT NULL, > name text CONSTRAINT the_name UNIQUE > ) WITH OIDS;/ > therefore I created these tables with the "LIKE" operator, see below: > / CREATE TABLE like_id_1( LIKE id_names INCLUDING DEFAULTS ) WITH OIDS; > CREATE TABLE like_id_2 ( LIKE id_names INCLUDING DEFAULTS ) WITH OIDS;
it looks like the syntax here is a little off from what is defined by: http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html CREATE TABLE like_id_1 ( id smallint like id_names, name text like id_name ) with oids ; Regards, Richard Broersma jr. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
