Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
От
Sebastien Flaesch
Тема
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Дата
Msg-id
DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
Ответ на
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column (Peter Eisentraut)
Список
Дерево обсуждения
Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch <sebastien.flaesch@4js.com>
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Thomas Kellerer <shammat@gmx.net>
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch <sebastien.flaesch@4js.com>
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch <sebastien.flaesch@4js.com>
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch <sebastien.flaesch@4js.com>
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch <sebastien.flaesch@4js.com>
Good point, thanks Peter!
Seb
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Sent: Wednesday, February 8, 2023 12:07 PM
To: Sebastien Flaesch <sebastien.flaesch@4js.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
Sent: Wednesday, February 8, 2023 12:07 PM
To: Sebastien Flaesch <sebastien.flaesch@4js.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
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.
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 по дате отправления
