Thread: Re: Select Multi Database / Need More;

Re: Select Multi Database / Need More;

From

"yudha"

Date:

29 November 2002, 02:06:54

Thank's for Milist's advices,

Dear Oliver Elphick <olly@lfix.co.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@candle.pha.pa.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.

Re: Select Multi Database / Need More;

From

Oliver Elphick

Date:

29 November 2002, 03:08:55

On Fri, 2002-11-29 at 19:08, yudha wrote:
> 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.

You need PostgreSQL 7.3, released yesterday.

junk=# \h create schema
Command:     CREATE SCHEMA
Description: define a new schema
Syntax:
CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ]
CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]


For example:

CREATE SCHEMA newjunk
   CREATE TABLE fred (id SERIAL PRIMARY KEY, fname TEXT)
   CREATE TABLE george (id SERIAL PRIMARY KEY, gname TEXT
);

--
Oliver Elphick <olly@lfix.co.uk>
LFIX Limited

Attachment

signature.asc