From: | "yudha" <yudha(at)BonBon(dot)net> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Select Multi Database / Need More; |
Date: | 2002-11-29 19:08:54 |
Message-ID: | 016501c297da$d0f2e840$ea00a8c0@yudha |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank's for Milist's advices,
Dear Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, You Wrote ;
>You cannot read from another database. In 7.3, you can have multiple
>schemas in one database and the syntax for reading a file from another
>schema is:
> SELECT * FROM schema.table...
-------------------------------------------------------------------------
Dear Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, You Wrote;
>You can't do cross-db queries directly. In 7.3, you can use schemas and
>put them all in the same database, or use /contrib/dblink for cross-db
>queries.
-------------------------------------------------------------------------
Then how could i make it (SCHEMA)..??
There are many tables split on 4 databases on my previous
databases (MS-SQL Server). Could you give me more
explanations about PostgreSQL-Schema. I've tried to search
about schema on many url but i still don't clearly understand
about "schema", there's no Create Schema command or
some command that's following with option schema. In the middle of
my confusing i tried to using command "create schema my_schema;"
it wasn't error show up, but my_schema that's i created is the same
with other database and it could dropped using "drop database my_schema".
So do you have any idea how to make a schema on PostgreSQL..??? and
anybody have any examples that's using "contrib/dblink"...???.
Sorry for very-basicly question.
Some Advices will be helpfull.
TIA and GOD Bless You.
From | Date | Subject | |
---|---|---|---|
Next Message | yudha | 2002-11-29 21:20:41 | Re: Select Multi Database / Cool. |
Previous Message | Oliver Elphick | 2002-11-29 05:08:57 | Re: Select Multi Database / Need More; |