Re: [GENERAL] pg_dump and schema namespace notes

2004-06-09 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Any comments on this? It seems like a valid confusion. What solutions > are there? I think we're stuck. We can't avoid the fact that the SQL syntax uses the keyword SCHEMA to mean a namespace. We also can't avoid the very common usage of "database sc

Re: [GENERAL] pg_dump and schema namespace notes

2004-06-09 Thread Joshua D. Drake
Bruce Momjian wrote: Any comments on this? It seems like a valid confusion. What solutions are there? A common interchangeable title for schema is namespace and in actuality we use \dn in psql (\dnamespace) to list them. Perhaps we should change the name? I believe Oracle uses the ter

Re: [GENERAL] pg_dump and schema namespace notes

2004-06-09 Thread Bruce Momjian
Any comments on this? It seems like a valid confusion. What solutions are there? --- Rory Campbell-Lange wrote: > I think this is a suggestion/comment! > > pg_dump man page: > > --schema-only > Dump o