|
Good point, thanks Peter!
Seb
From: Peter Eisentraut <peter.eisentraut@xxxxxxxxxxxxxxxx>
Sent: Wednesday, February 8, 2023 12:07 PM To: Sebastien Flaesch <sebastien.flaesch@xxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx> Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column EXTERNAL: Do not click links or open attachments if you do not recognize the sender.
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. |
