Re: Regclass and quoted table names

Greg Stark <stark@enterprisedb.com> writes:
> On Wed, Mar 4, 2009 at 12:34 PM, Emmanuel Cecchet <manu@asterdata.com> wrote:
>> This is problematic in situations where the output of the cast is involved
>> in some later join which returns incorrect results because of the extra
>> double quotes surrounding the table name. Is there a way to override the
>> default behavior to have a consistent quoted or non-quoted result?

> regclass's output format is intended for human readers, not for
> joining against text columns. Why would you need to be joining between
> regclass and text anyways?

The quoting behavior is the *least* of your problems if you're trying to
do that.  Are you aware of how it works vis-a-vis search_path?  Have you
thought about what will happen when you rename a table?

Use plain oids or regclass values, not a text column, if you are trying
to store table identities.
        regards, tom lane