i'm using pgAdmin III - 1.6.1 - rev:5709 win32 binary version
when i try to view table details, sometimes foreign keys comes with missing column names which causes a syntax error when i try to recreate or copy table. ex: pgAdmin III: --------------------- CONSTRAINT xxx_yyy_fkey FOREIGN KEY () REFERENCES yyy () MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION original pgdump of table: ----------------------------------- ALTER TABLE ONLY xxx ADD CONSTRAINT xxx_yyy_fkey FOREIGN KEY (yyy) REFERENCES yyy(id); regards erbiL... ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate