MIME-Version: 1.0
References: <61f2cfed.17a9.1999f3ab6b2.Coremail.msdnchina@163.com>
In-Reply-To: <61f2cfed.17a9.1999f3ab6b2.Coremail.msdnchina@163.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 1 Oct 2025 07:07:57 -0400
Message-ID: 
 <CAKAnmmK5VkXQge6iCn4QDvnmBRrnrxcw0LLoLw3EPTpHgoPWDw@mail.gmail.com>
Subject: 
 =?UTF-8?Q?Re=3A_in_the_different_schema_=EF=BC=8Cthe_sequence_name_is_?=
	=?UTF-8?Q?same=EF=BC=8C_and_a_table=27s_column_definition_use_this_sequence=2Cso?=
	=?UTF-8?Q?=EF=BC=8Chow_can_I_identify_sequence=27s_schema_name_by_system_view=2F?=
	=?UTF-8?Q?table=3A?=
To: yanliang lei <msdnchina@163.com>
Cc: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a1a6d4064016e39c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKAnmmK5VkXQge6iCn4QDvnmBRrnrxcw0LLoLw3EPTpHgoPWDw%40mail.gmail.com>
Precedence: bulk

--000000000000a1a6d4064016e39c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Oct 1, 2025 at 6:04=E2=80=AFAM yanliang lei <msdnchina@163.com> wro=
te:

>  the column c1 in the schema_1.test_tab_100 is associated with which
> sequence ?? *schema_1*.seq_xx_yy or *public*.seq_xx_yy??
>

This is better asked on the pgsql-general mailing list, but the short
answer is that you have to look at your search_path as well. Since you just
created schema_1, and public is in your search_path, a plain seq_xx_yy is
the one from the public schema. To see the fully-qualified name, run:

SET search_path =3D pg_catalog;

before issuing your select from information_schema.columns

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000a1a6d4064016e39c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Oct 1, 2025 at 6:04=E2=80=AFAM ya=
nliang lei &lt;<a href=3D"mailto:msdnchina@163.com">msdnchina@163.com</a>&g=
t; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote=
 class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex"><div style=3D"line-height:1.7;color:=
rgb(0,0,0);font-size:14px;font-family:Arial"><div>=C2=A0the column c1 in th=
e  schema_1.test_tab_100   is associated with  which sequence ??  <b><span =
style=3D"color:rgb(221,64,50)">schema_1</span></b>.seq_xx_yy or <b><span st=
yle=3D"color:rgb(83,139,215)">public</span></b>.seq_xx_yy??</div></div></bl=
ockquote><div><br></div><div>This is better asked on the pgsql-general mail=
ing list, but the short answer=C2=A0is that you have to look at your search=
_path as well. Since you just created schema_1, and public is in your searc=
h_path, a plain seq_xx_yy is the one from the public schema. To see the ful=
ly-qualified name, run:</div><div><br></div><div>SET search_path =3D pg_cat=
alog;</div><div><br></div><div>before issuing your select from information_=
schema.columns</div><div>=C2=A0</div></div><div dir=3D"ltr" class=3D"gmail_=
signature"><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div><br></div=
><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com" t=
arget=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise Postg=
res Software Products &amp; Tech Support</div><div><br></div></div></div></=
div>

--000000000000a1a6d4064016e39c--