Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Date
Msg-id 10d743ad-2216-df5b-a966-38f154a6f53a@enterprisedb.com
Whole thread Raw
In response to Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
Responses Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
List pgsql-general
Tree view 
On 07.02.23 11:43, Sebastien Flaesch wrote:
> select '"'||ns.nspname||'"."'||p.relname||'"' tabname, c.attname colname

Just a side note: You might find the quote_ident() function useful.

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Switching identity column to serial
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Sequence vs UUID