Re: Join between databases or (???)

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/
>