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/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
