|
Thank's for Milist's advices,
Dear Oliver Elphick
<[EMAIL PROTECTED]>,
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 <[EMAIL PROTECTED]>, 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. |
