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