Skip site navigation (1) Skip section navigation (2)

Re: Is there a way to find a schema name

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Kalyani Chennupati <k_chennupati(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Is there a way to find a schema name
Date: 2005-03-27 08:22:09
Message-ID: 20050327082209.GB46534@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-sql
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/

In response to

pgsql-sql by date

Next:From: Franz StuetzleDate: 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 FuhrDate: 2005-03-27 08:09:51
Subject: Re: Accessing other Databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group