Hi,

I have some schema queries/thoughts that I would appreciate some
help/insights/fixes with/for please!

(Apologies if these have been asked before or have been addressed in a
recent snapshot - my ISP's been having routing problems recently & I
can't reach postgresql.org via http right now).

1) All the system views are currently part of the public namespace. Not
a problem for me, but shouldn't they be in pg_catalog?

2) pgAdmin needs to be able to find out the namespace search path for
the current connection through an SQL query - is this possible yet or
can/will a suitable function be written?

There were more than that when I started typing this but I had a flash
of inspiration and they went away :-)

TIA,

Regards, Dave.

Fri, 17 May 2002 16:32:21 +0100
"Dave Page" <dpage@vale-housing.co.uk>
More schema queries
"Dave Page" <dpage@vale-housing.co.uk> writes:
> 1) All the system views are currently part of the public namespace. Not
> a problem for me, but shouldn't they be in pg_catalog?

Say what?  They *are* in pg_catalog.  initdb creates nothing in public.

> 2) pgAdmin needs to be able to find out the namespace search path for
> the current connection through an SQL query - is this possible yet or
> can/will a suitable function be written?

Either 'show search_path' or 'select current_schemas()' might do what
you want; or perhaps not.  Why do you want to know the search path?
What's the scenario in which pgAdmin wouldn't set the search path
for itself?

			regards, tom lane

Fri, 17 May 2002 16:25:49 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: More schema queries 