Thread: Is there a way to find a schema name

Would like to know if there is a way to find a schema
name (when in the schema through a application or
through psql).

Thanks
KC

On Thu, Mar 24, 2005 at 08:03:48AM -0800, Kalyani Chennupati wrote:

> Would like to know if there is a way to find a schema
> name (when in the schema through a application or
> through psql).

See "System Information Functions" (or "Miscellaneous Functions")
in the "Functions and Operators" chapter of the documentation.
Here's a link to the documentation for the latest release:

http://www.postgresql.org/docs/8.0/interactive/functions-info.html

See also the "System Catalogs" chapter -- you can do joins on
pg_class.relnamespace = pg_namespace.oid, for example.

http://www.postgresql.org/docs/8.0/interactive/catalogs.html

If this doesn't answer your question then please be more specific
about what you're trying to do.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/