Re: Bug with DatabaseMetaData and temporary tables/schemas - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Bug with DatabaseMetaData and temporary tables/schemas
Date
Msg-id 12764.1289091761@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug with DatabaseMetaData and temporary tables/schemas  (Kris Jurka <books@ejurka.com>)
Responses Re: Bug with DatabaseMetaData and temporary tables/schemas
List pgsql-jdbc
Kris Jurka <books@ejurka.com> writes:
> It looks like psql will show you your own temp schema and all of the
> temp toast schemas.  So that could potentially be improved as well.

Yeah, there was some discussion of that just recently:
http://archives.postgresql.org/message-id/16710.1284837096@sss.pgh.pa.us

I haven't got round to making that change yet, but maybe now is a
good time.  The consensus seemed to be that \dn (without S) should
not show any pg_XXX schemas, nor information_schema.  Not sure that
that's appropriate for getSchemas though --- an API intended for
programs should maybe just hide the temp and toast schemas.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Bug with DatabaseMetaData and temporary tables/schemas
Next
From: Thomas Kellerer
Date:
Subject: Re: Bug with DatabaseMetaData and temporary tables/schemas