Postgres Pro
Downloads
Home   >   mailing lists

Re: Serial sequence name when table/column name in uppercase - Mailing list pgsql-sql

From Tom Lane
Subject Re: Serial sequence name when table/column name in uppercase
Date
Msg-id 3167888.1617198904@sss.pgh.pa.us
Whole thread Raw
In response to Re: Serial sequence name when table/column name in uppercase  (Sebastien FLAESCH <sf@4js.com>)
Responses Re: Serial sequence name when table/column name in uppercase  (Sebastien FLAESCH <sf@4js.com>)
Re: Serial sequence name when table/column name in uppercase  (Sebastien FLAESCH <sf@4js.com>)
List pgsql-sql
Tree view 
Sebastien FLAESCH <sf@4js.com> writes:
> Ok thanks a lot I got it now, must specify double-quotes around table name.

You could use quote_ident() if you don't want to be bothered with the
rules for when to double-quote.  Also, if you have the table's OID at
hand in the query, oid::regclass::text will produce a properly quoted
and schema-qualified name.

            regards, tom lane

pgsql-sql by date:

Previous
From: Sebastien FLAESCH
Date:
Subject: Re: Serial sequence name when table/column name in uppercase
Next
From: Sebastien FLAESCH
Date:
Subject: Re: Serial sequence name when table/column name in uppercase