Thread: AW: AW: Unhappy thoughts about pg_dump and objects inhe rited from template1

AW: AW: Unhappy thoughts about pg_dump and objects inhe rited from template1

From
Zeugswetter Andreas SB
Date:
> 3. Schemas are what we call databases. They contain tables, views wtc.

Let us not start this all over again. Our database would correspond to a catalog
if we put schemas below our database hierarchy.

The standard requires, that you see all schemas within one catalog in 
one user session. We do not see tables in another database,
thus our database is not equivalent to ANSI schemas.

The standard also requires, that you can qualify a tablename with a schema,
like: "myschema".tabname. This will be the most difficult thing for us.

Andreas