MIME-Version: 1.0
References: 
 <SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572@SJ0PR11MB5629.namprd11.prod.outlook.com>
 <174178.1708553636@sss.pgh.pa.us>
In-Reply-To: <174178.1708553636@sss.pgh.pa.us>
From: Nisarg Patel <er.nisarg@gmail.com>
Date: Wed, 21 Feb 2024 18:17:15 -0500
Message-ID: 
 <CAA=RfSPoPw0ERRGEQTVGYvAzJjES42At0bhxCNvW1x_LnAu0nw@mail.gmail.com>
Subject: Re: How to find all current sequence IDs
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Campbell, Lance" <lance@illinois.edu>, pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000009742890611ec87fa"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA%3DRfSPoPw0ERRGEQTVGYvAzJjES42At0bhxCNvW1x_LnAu0nw%40mail.gmail.com>
Precedence: bulk

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

This has worked for me in the past:
select schemaname, sequencename, last_value
from pg_sequences;

Thank you,
Nisarg

On Wed, Feb 21, 2024, 5:14=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Campbell, Lance" <lance@illinois.edu> writes:
> > Is there a way to get a list of all sequences, the schema it is used in=
,
> and the current sequence number in use?
>
> Try something like
>
> select relname, relnamespace::regnamespace, pg_sequence_last_value(oid)
> from pg_class where relkind =3D 'S';
>
>                         regards, tom lane
>
>
>

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

<div dir=3D"auto"><div>This has worked for me in the past:</div><div dir=3D=
"auto">select schemaname, sequencename, last_value</div><div dir=3D"auto">f=
rom pg_sequences;</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thank =
you,</div><div dir=3D"auto">Nisarg<br><br><div class=3D"gmail_quote" dir=3D=
"auto"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Feb 21, 2024, 5:14=E2=
=80=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.u=
s</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin=
:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">&quot;Campbell, La=
nce&quot; &lt;<a href=3D"mailto:lance@illinois.edu" target=3D"_blank" rel=
=3D"noreferrer">lance@illinois.edu</a>&gt; writes:<br>
&gt; Is there a way to get a list of all sequences, the schema it is used i=
n, and the current sequence number in use?<br>
<br>
Try something like<br>
<br>
select relname, relnamespace::regnamespace, pg_sequence_last_value(oid)<br>
from pg_class where relkind =3D &#39;S&#39;;<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
<br>
<br>
</blockquote></div></div></div>

--0000000000009742890611ec87fa--