I need a pointer to the appropriate docs that show me how to specify a table in a different database. What I want is to CREATE TABLE <tablename> AS TABLE <otherdatabase><same_tablename>; but using a period (dot) to separate the source database and table name doesn't work. My searches of the 9.0.x docs have missed finding this information. TIA, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
