From: "Campbell, Lance" <lance@illinois.edu>
To: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Subject: How to find all current sequence IDs
Thread-Topic: How to find all current sequence IDs
Thread-Index: AdplEeGZC3bv1xCJS22Xho2MnYzAsQ==
Date: Wed, 21 Feb 2024 22:06:55 +0000
Message-ID: 
 <SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572@SJ0PR11MB5629.namprd11.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?ujoqYpYPOd8bEarKNisOvIgdDZex5QvBUjalRSOSTV2i5PNK4nXPBGpIYvQ+?=
 =?us-ascii?Q?HETFOEFYjm/oaSdRaxOJCretZiEgSTn4Acn/f0PWSy2uNHanXABOnEpo+bet?=
 =?us-ascii?Q?uYNIx278bZx6BwnXk12nsD+5J3d1iVK5S5if74Q/Q31mUN7+f1D7mb674Lcb?=
 =?us-ascii?Q?dB4iWvjqGrC0dnQDnXcotc6olquT3yoTk1lkPlDFUY1wKrdB+DHxGzv6Rpnp?=
 =?us-ascii?Q?r2I9cPYT7nbJj6o7S/glH19GeqS0lwmWpS/7HmdFrqu3xwYuZAnfdQXpFkE6?=
 =?us-ascii?Q?YP6N9dw90FPQpW3/cbJDLLDk6N4T5OXWTMmlz9cZLD2H719ve8FA/3r/whmi?=
 =?us-ascii?Q?WUvpjlow1TA+qbz9WRztFKploFt66NJTkf2ugu4Mc3fsXD71llLi57gzHB4l?=
 =?us-ascii?Q?GkKUMRz/q3Xvabvih4BZTJwF45vzQTXRJE2jOSXgkp1RvbkvB96C31BHXCVy?=
 =?us-ascii?Q?+8LUerv/FcBvckDxS0PfgzSsO5UF9h0I/R4lOSTKKjtMoIzZc2wQZNbIFT+f?=
 =?us-ascii?Q?6NHFyx6BsVXCGaPnDhes7u0GHFEt4dDELCaKKVS8T7L9BqrjZsD6lDsWOzSp?=
 =?us-ascii?Q?e1w+HA0RbVM8jWJ8Qm9JJsT/02Z7ozw/sfGucnfO1kk6/81xQtCzo9X9uQZ7?=
 =?us-ascii?Q?9c8MsyEbIOph3rhUfLK7PA1BUeg8O71zWvvECgctVxC9cwLGFJK0qWG9JXGP?=
 =?us-ascii?Q?41hkReH10T9lPufjzSbVdFuSqM5Qu82YzWLR0V/dl169OG+1pVLZXMUaGFeg?=
 =?us-ascii?Q?NqGX7CpzeilHoklPrZwdWTBV/c+73kc7kNYVl7VUxmi+nJDU7a6rJtem4CHf?=
 =?us-ascii?Q?+HTz5EklrLCtuLmzbLAdlDayXO+z4RDmlMg8Aw0KmUukBZoeFM1CYWArerEr?=
 =?us-ascii?Q?LiMEc5h1aaJ1UqPN5P0SsZ2ILxdYd6bgN7SUDXlVthDGawnPwm6NkB69Sc0e?=
 =?us-ascii?Q?Jh8KfOTofp3wOzX7MrvPCORRN7jLnhlfG02W9Z0NH3tFcF7zDcZam7C28g18?=
 =?us-ascii?Q?8prDANgy7iFeFCGNgxb6ENZ+ZR38/U8p2W3MRXiBxOroxeGO+XrUQSa5kT0S?=
 =?us-ascii?Q?h3cOu69uN0wbCyFt7yHSSjm5CDNRgEml6fRxxKSW7dayk10eYc1qp8z+dt9G?=
 =?us-ascii?Q?mFvWwee0B9WN/LpU5tpYxDXw6IDEAAacxEDkChr/V1wHGDN3ZN7sWHLrVVWh?=
 =?us-ascii?Q?F07ufw5XUnCtmicyEWtMl5FItQGGLlvUiDJwj1HX6KliiinOkZcNv88hXs0k?=
 =?us-ascii?Q?XfLQ2vD0gABtxLRaOJaaR0zqb536uWNbKHyUzUOngSUdIXvjEa7rZhjOV+Es?=
 =?us-ascii?Q?nEy65dwK5mWivI579DTPK3My9qneW0X18OyU5HeugGzy0FuqPq9XBNOK7C2k?=
 =?us-ascii?Q?eJ04Uw7JyyeJNCWmp82Cvjd1O24wzG6uAtATAFt1dmvsEeT1MNh+wZBpDny1?=
 =?us-ascii?Q?KT+aFZN98eoJoDpITrn1rN4+yy2pjuPfqExq+mRcwwNfRvJhE9XLHdXFHW6d?=
 =?us-ascii?Q?jxxN7lkmZmAz/9CYxc2dBRVsXS6ieRDKLGJgvouXz054poeljtbH01AV2eB6?=
 =?us-ascii?Q?IIZjJGXkCWnFH3r31+bvsegg34sHjwjFamSyNB7g?=
Content-Type: multipart/alternative;
	boundary="_000_SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572SJ0PR11MB5629namp_"
MIME-Version: 1.0
X-OriginatorOrg: illinois.edu
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SJ0PR11MB5629.namprd11.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 ef4fb87a-f144-402c-bb10-08dc33296a6a
X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Feb 2024 22:06:55.1793
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 44467e6f-462c-4ea2-823f-7800de5434e3
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 PixOwUXNf3Kw8AcnRsx+1yF8JaeAweaydnllb0mLE6t8CvZmtMRqC/iWLZF4IsDYbzgHG2d/EE+bCArBjWvkrA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH0PR11MB5644
X-Proofpoint-GUID: KyQfWFUrdKV1aVoBcIgSrucQQ-wCGJ_w
X-Proofpoint-ORIG-GUID: KyQfWFUrdKV1aVoBcIgSrucQQ-wCGJ_w
X-Spam-Details: rule=cautious_plus_nq_notspam policy=cautious_plus_nq score=0
 impostorscore=0 malwarescore=0 mlxlogscore=701 priorityscore=1501
 bulkscore=0 phishscore=0 suspectscore=0 clxscore=1011 mlxscore=0
 lowpriorityscore=0 spamscore=0 adultscore=0 classifier=spam adjust=0
 reason=mlx scancount=1 engine=8.12.0-2311290000
 definitions=main-2402210174
X-Spam-Score: 0
X-Spam-OrigSender: lance@illinois.edu
X-Spam-Bar: 
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572%40SJ0PR11MB5629.namprd11.prod.outlook.com>
Precedence: bulk

--_000_SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572SJ0PR11MB5629namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Is there a way to get a list of all sequences, the schema it is used in, an=
d the current sequence number in use?

The below SQL will give me the schema and sequences. It does not give me th=
e current sequence number in use.

SELECT sequence_schema, sequence_name
FROM information_schema.sequences
ORDER BY sequence_name ;

Thanks,

Lance Campbell
University of Illinois

--_000_SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572SJ0PR11MB5629namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Is there a way to get a list of all sequences, the s=
chema it is used in, and the current sequence number in use?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">The below SQL will give me the schema and sequences.=
 It does not give me the current sequence number in use.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">SELECT sequence_schema, sequence_name <o:p></o:p></p=
>
<p class=3D"MsoNormal">FROM information_schema.sequences <o:p></o:p></p>
<p class=3D"MsoNormal">ORDER BY sequence_name ;<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Lance Campbell<o:p></o:p></p>
<p class=3D"MsoNormal">University of Illinois<o:p></o:p></p>
</div>
</body>
</html>

--_000_SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572SJ0PR11MB5629namp_--