Postgres Pro
Downloads
Home   >   mailing lists

Re: Dealing with table names in functions - Mailing list pgsql-general

From Tom Lane
Subject Re: Dealing with table names in functions
Date
Msg-id 3640.1174577472@sss.pgh.pa.us
Whole thread Raw
In response to Dealing with table names in functions  (Jim Nasby <decibel@decibel.org>)
List pgsql-general
Tree view 
Jim Nasby <decibel@decibel.org> writes:
> ... I can cast the OID to regclass, but that
> doesn't get me a fully-qualified name.

It does if the name needs to be qualified given your current search_path.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: questions about query design
Next
From: Douglas McNaught
Date:
Subject: Re: Configuring phpPgAdmin and pg_ctl reload