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 <[EMAIL PROTECTED]> LFIX Limited
signature.asc
Description: This is a digitally signed message part
