Good point, thanks Peter!
Seb
________________________________
From: Peter Eisentraut <[email protected]>
Sent: Wednesday, February 8, 2023 12:07 PM
To: Sebastien Flaesch <[email protected]>; 
[email protected] <[email protected]>
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.

Reply via email to