Thanks for all your help Michael! I am having one problem I just can't figure out.... In my dump file I have something like: CREATE SEQUENCE testschema.industries_industry_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; );
CREATE TABLE testschema.industries ( industry_id integer DEFAULT nextv al('"testschema.industries_industry_id_seq"'::text) NOT NULL, industry character varying(80) NOT NULL, entered_dt timestamp with time zone, updated_dt timestamp with time zone ); When I try to insert a value into schema.industries it complains about testschema.industries_industry_id_seq not existing, yet I can execute "nextval" against that very schema.... Any idea what might be going wrong here?... Thanks! - Greg >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 8: explain analyze is your friend