pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sebastien Flaesch <sebastien.flaesch@4js.com>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: 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
Date: Wed, 8 Feb 2023 13:00:21 +0000
Message-ID: <DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <10d743ad-2216-df5b-a966-38f154a6f53a@enterprisedb.com>
References: <DBAP191MB12892E942BD10BC2F46A354EB0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
	<d0102694-471a-08c2-faf7-27e0366cb834@gmx.net>
	<DBAP191MB1289E9989C9F934FC4E54979B0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
	<DBAP191MB128986E553FB3D1D9DD465C1B0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
	<DBAP191MB12892B0FF0E108C08A92B655B0DB9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
	<10d743ad-2216-df5b-a966-38f154a6f53a@enterprisedb.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

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.

view thread (7+ messages)

Message-ID: <DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
Permalink:  ../DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM/
Also on:    postgresql.org/message-id/DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: sebastien.flaesch@4js.com, peter.eisentraut@enterprisedb.com
  Subject: Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column
  In-Reply-To: <DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
  References: <DBAP191MB12892E942BD10BC2F46A354EB0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <d0102694-471a-08c2-faf7-27e0366cb834@gmx.net> <DBAP191MB1289E9989C9F934FC4E54979B0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <DBAP191MB128986E553FB3D1D9DD465C1B0DA9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <DBAP191MB12892B0FF0E108C08A92B655B0DB9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <10d743ad-2216-df5b-a966-38f154a6f53a@enterprisedb.com> <DBAP191MB1289C9AE83CB97AFE54B9DC3B0D89@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox