namespace in pgsql

From: Bhavik <bhavikdbavishi(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: namespace in pgsql
Date: 2008-09-25 07:19:01
Message-ID: dae43eb3-8bd3-4ff7-8c8e-9933700ea2c7@s9g2000prg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am newbie for pgsql..... Im using Solaris.....

1) Is it possible to have namespace like in OOP, in pgsql query.....
means as I know we can reference table or its column with fashion like
<schema>.<table_name>, but is it possible like
<db_name>.<schema>.<table_name> ???

2) Is it fine if I store all data in one db ( well most of the table
with 2000+ rows ) ? OR better to created 2-3 dbs and store those
tables...

Thanks in advance...... (" ,)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tommy Gildseth 2008-09-25 08:42:09 Minor bug/inconveniance with restore from backup, using PITR base backup and archived wal files
Previous Message Tomasz Ostrowski 2008-09-25 07:18:26 Re: pg_dump | pg_sql: insert commands and foreign key constraints