Schema uniqueness

#1

I have one database (e.g. database1) with two schemas (e.g. schema1 and schema2).
Each schema has distinct tables.

For some reason my barin is siezing today! I just need somebody to refresh my memory:
1) can a tablename be duplicated in two schemas, i.e. schema1.tablename1 and schema2.tablename1?
2) similarly, can a schema name be duplicated across different databases?

Thanks.

#2

gargoyle60, 28.06.2010 11:26:

Quote:

1) can a tablename be duplicated in two schemas, i.e. schema1.tablename1 and schema2.tablename1?
yes

Quote:

2) similarly, can a schema name be duplicated across different databases?
yes

#3

On Mon, 28 Jun 2010 11:33:56 +0200, Thomas Kellerer <OTPXDAJCSJVU (AT) spammotel (DOT) com> wrote:

Quote:

gargoyle60, 28.06.2010 11:26:

1) can a tablename be duplicated in two schemas, i.e. schema1.tablename1 and schema2.tablename1?
yes

2) similarly, can a schema name be duplicated across different databases?
yes

Thanks for the swift reply.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Schema uniqueness

comp.databases.postgresql comp.databases.postgresql

Schema uniqueness - 06-28-2010 , 05:26 AM

Re: Schema uniqueness - 06-28-2010 , 05:33 AM

Re: Schema uniqueness - 06-28-2010 , 05:35 AM