On Sat, Nov 20, 2004 at 07:37:12PM -0700, Net Virtual Mailing Lists wrote: > If I want to take an existing table and add it into a schema is it > basically "alter database [database] rename [table] to schema.[table]"?....
Unfortunately not. See a recent thread in pgsql-sql that discussed this: http://archives.postgresql.org/pgsql-sql/2004-11/msg00139.php > .. I guess that I was just looking for confirmation there was not > something in postgres which would allow this "full featured cross- > database join" before pulling an a few all nighters... PostgreSQL doesn't have any inherent cross-database capabilities. You can use dblink to query another database and join the results against the current database, but its capabilities probably aren't what you'd consider "full-featured." Still, you might want to check it out if you're not familiar with it. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
