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:
See also the "System Catalogs" chapter -- you can do joins on
pg_class.relnamespace = pg_namespace.oid, for example.
If this doesn't answer your question then please be more specific
about what you're trying to do.
In response to
pgsql-sql by date
|Next:||From: Franz Stuetzle||Date: 2005-03-27 12:17:38|
|Subject: Postgre: 8.0.1 Create Table insde a function gives strange error at execution time|
|Previous:||From: Michael Fuhr||Date: 2005-03-27 08:09:51|
|Subject: Re: Accessing other Databases|