且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在 Postgres 中获取序列名称列表?

更新时间:2023-11-20 19:54:10

SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
或者尝试以 psql -U username -E 后跟 \ds 的方式运行 psql.这也会显示用于生成结果的查询.

SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
Or trying running psql as psql -U username -E followed by \ds. This will show you the query that was been used to generate the result as well.