Marti Raudsepp writes:
> The documentation says: The view schemata contains all schemas in the
> current database that are owned by a currently enabled role.
> In other words: this view only displays schemas that are *owned* by
> your user, or roles that your current user inherits from (superuser
On 25 October 2011 17:04, Marti Raudsepp wrote:
> On Mon, Oct 24, 2011 at 23:23, Szymon Guz wrote:
> > String query1 = "SELECT * FROM information_schema.schemata WHERE
> schema_name = ?";
>
> > When I query the database using psql, both queries return sensible data
> > (even when I prepare state
On Mon, Oct 24, 2011 at 23:23, Szymon Guz wrote:
> String query1 = "SELECT * FROM information_schema.schemata WHERE schema_name
> = ?";
> When I query the database using psql, both queries return sensible data
> (even when I prepare statements in postgres).
> I'd like to use information_schema r
Hi,
I've got a quite strange situation. Below is a simple test
@Test
public void test() throws SQLException {
String query1 = "SELECT * FROM information_schema.schemata WHERE
schema_name = ?";
String query2 = "SELECT * FROM pg_catalog.pg_namespace where nspname
= ?";
