blocks|key|327183|text|使用-E标志启动psql+(“回应\d和其他反斜杠命令生成的实际查询”)，然后输入\ds命令以列出所有序列。您应该会看到类似下面这样的内容：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|327184|#+\ds
*********+QUERY+**********
SELECT+n.nspname+as+"Schema",
++c.relname+as+"Name",
++CASE+c.relkind+WHEN+'r'+THEN+'table'+WHEN+'v'+THEN+'view'+WHEN+'m'+THEN+'materialized+view'+WHEN+'i'+THEN+'index'+WHEN+'S'+THEN+'sequence'+WHEN+'s'+THEN+'special'+WHEN+'f'+THEN+'foreign+table'+WHEN+'p'+THEN+'partitioned+table'+WHEN+'I'+THEN+'partitioned+index'+END+as+"Type",
++pg_catalog.pg_get_userbyid(c.relowner)+as+"Owner"
FROM+pg_catalog.pg_class+c
+++++LEFT+JOIN+pg_catalog.pg_namespace+n+ON+n.oid+=+c.relnamespace
WHERE+c.relkind+IN+('S','')
++++++AND+n.nspname+<>+'pg_catalog'
++++++AND+n.nspname+<>+'information_schema'
++++++AND+n.nspname+!~+'%5Epg_toast'
++AND+pg_catalog.pg_table_is_visible(c.oid)
ORDER+BY+1,2;
**************************

+++++++++++++++++++++List+of+relations
+Schema+%7C++++++++++++++Name++++++++++++++%7C+++Type+++%7C+Owner+
--------%2B--------------------------------%2B----------%2B-------
+public+%7C+assignments_id_seq+++++++++++++%7C+sequence+%7C+root
+public+%7C+framework_users_id_seq+++++++++%7C+sequence+%7C+root
+public+%7C+lending_items_id_seq+++++++++++%7C+sequence+%7C+root
+public+%7C+proxy_borrower_requests_id_seq+%7C+sequence+%7C+root
+public+%7C+roles_id_seq+++++++++++++++++++%7C+sequence+%7C+root
+public+%7C+stack_requests_id_seq++++++++++%7C+sequence+%7C+root
(6+rows)|code-block|syntax|javascript|327185|要检查特定的序列，可以运行\d+<sequence+name>|327186|#+\d+lending_items_id_seq
*********+QUERY+**********

(...about+four+queries...)

**************************

++++++++++++++++++++Sequence+"public.lending_items_id_seq"
++Type++%7C+Start+%7C+Minimum+%7C+++++++Maximum+++++++%7C+Increment+%7C+Cycles?+%7C+Cache+
--------%2B-------%2B---------%2B---------------------%2B-----------%2B---------%2B-------
+bigint+%7C+++++1+%7C+++++++1+%7C+9223372036854775807+%7C+++++++++1+%7C+no++++++%7C+++++1
Owned+by:+public.lending_items.id|327187|entityMap^0|2|2|8|4|H|2|15|3|0|0|D|I|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|P|$]]

Launch <code>psql</code> with the <code>-E</code> flag (&quot;echo the actual queries generated by <code>\d</code> and other backslash commands&quot;), then enter the <code>\ds</code> command to list all sequences. You should see something like this:
<pre class="lang-none prettyprint-override"><code># \ds
********* QUERY **********
SELECT n.nspname as &quot;Schema&quot;,
 c.relname as &quot;Name&quot;,
 CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' WHEN 'I' THEN 'partitioned index' END as &quot;Type&quot;,
 pg_catalog.pg_get_userbyid(c.relowner) as &quot;Owner&quot;
FROM pg_catalog.pg_class c
 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('S','')
 AND n.nspname &lt;&gt; 'pg_catalog'
 AND n.nspname &lt;&gt; 'information_schema'
 AND n.nspname !~ '^pg_toast'
 AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
**************************

 List of relations
 Schema | Name | Type | Owner 
--------+--------------------------------+----------+-------
 public | assignments_id_seq | sequence | root
 public | framework_users_id_seq | sequence | root
 public | lending_items_id_seq | sequence | root
 public | proxy_borrower_requests_id_seq | sequence | root
 public | roles_id_seq | sequence | root
 public | stack_requests_id_seq | sequence | root
(6 rows)
</code></pre>
To examine a particular sequence, you can then run <code>\d &lt;sequence name&gt;</code>:
<pre class="lang-none prettyprint-override"><code># \d lending_items_id_seq
********* QUERY **********

(...about four queries...)

**************************

 Sequence &quot;public.lending_items_id_seq&quot;
 Type | Start | Minimum | Maximum | Increment | Cycles? | Cache 
--------+-------+---------+---------------------+-----------+---------+-------
 bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
Owned by: public.lending_items.id
</code></pre>

blocks|key|3299820|text|稍微痛了一下，我就明白了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3299821|实现这一点的最好方法是列出所有表|3299822|select+*+from+pg_tables+where+schemaname+=+'<schema_name>'|code-block|syntax|javascript|3299823|然后，对于每个表，列出具有属性的所有列|3299824|select+*+from+information_schema.columns+where+table_name+=+'<table_name>'|3299825|然后，对于每一列，测试它是否有一个序列|3299826|select+pg_get_serial_sequence('<table_name>',+'<column_name>')|3299827|然后，获取有关此序列的信息|3299828|select+*+from+<sequence_name>|3299829|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

after a little bit of pain, i got it.

the best way to achieve this is to list all tables

<pre><code>select * from pg_tables where schemaname = '&lt;schema_name&gt;'
</code></pre>

and then, for each table, list all columns with attributes

<pre><code>select * from information_schema.columns where table_name = '&lt;table_name&gt;'
</code></pre>

then, for each column, test if it has a sequence

<pre><code>select pg_get_serial_sequence('&lt;table_name&gt;', '&lt;column_name&gt;')
</code></pre>

and then, get the information about this sequence

<pre><code>select * from &lt;sequence_name&gt;
</code></pre>

blocks|key|3299845|text|部分测试，但看起来基本完成。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3299846|select+*
++from+(select+n.nspname,c.relname,
+++++++++++++++(select+substring(pg_catalog.pg_get_expr(d.adbin,+d.adrelid)+for+128)
++++++++++++++++++from+pg_catalog.pg_attrdef+d
+++++++++++++++++where+d.adrelid=a.attrelid
+++++++++++++++++++and+d.adnum=a.attnum
+++++++++++++++++++and+a.atthasdef)+as+def
++++++++++from+pg_class+c,+pg_attribute+a,+pg_namespace+n
+++++++++where+c.relkind='r'
+++++++++++and+c.oid=a.attrelid
+++++++++++and+n.oid=c.relnamespace
+++++++++++and+a.atthasdef
+++++++++++and+a.atttypid=20)+x
+where+x.def+~+'%5Enextval'
+order+by+nspname,relname;|code-block|syntax|javascript|3299847|值得表扬的地方...它在一定程度上是从具有序列的已知表的a+\d中记录的SQL逆向工程而来的。我相信它也可以更干净，但是嘿，性能不是问题。|3299848|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Partially tested but looks mostly complete.

<pre><code>select *
 from (select n.nspname,c.relname,
 (select substring(pg_catalog.pg_get_expr(d.adbin, d.adrelid) for 128)
 from pg_catalog.pg_attrdef d
 where d.adrelid=a.attrelid
 and d.adnum=a.attnum
 and a.atthasdef) as def
 from pg_class c, pg_attribute a, pg_namespace n
 where c.relkind='r'
 and c.oid=a.attrelid
 and n.oid=c.relnamespace
 and a.atthasdef
 and a.atttypid=20) x
 where x.def ~ '^nextval'
 order by nspname,relname;
</code></pre>

Credit where credit is due... it's partly reverse engineered from the SQL logged from a \d on a known table that had a sequence. I'm sure it could be cleaner too, but hey, performance wasn't a concern.

blocks|key|3086852|text|下面的查询给出了所有序列的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086853|SELECT+c.relname+FROM+pg_class+c+WHERE+c.relkind+=+'S';|code-block|syntax|javascript|3086854|通常，序列被命名为${table}_id_seq。简单的正则表达式模式匹配将为您提供表名。|offset|length|style|CODE|3086855|要获取序列的最后一个值，请使用以下查询：|3086856|SELECT+last_value+FROM+test_id_seq;|3086857|entityMap^0|0|0|9|F|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

The following query gives names of all sequences.

<pre><code>SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
</code></pre>

Typically a sequence is named as <code>${table}_id_seq</code>. Simple regex pattern matching will give you the table name.

To get last value of a sequence use the following query:

<pre><code>SELECT last_value FROM test_id_seq;
</code></pre>

blocks|key|3086883|text|自动生成的序列(例如为序列列创建的序列)和父表之间的关系由序列所有者属性建模。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086884|您可以使用ALTER+SEQUENCE+commmand的OWNED子句修改此关系|offset|length|3086885|例如foo_schema.foo_table拥有的ALTER+SEQUENCE+foo_id|3086886|将其设置为链接到表foo_table|3086887|或ALTER+SEQUENCE+foo_id由NONE拥有|3086888|断开序列和任意表之间的连接|3086889|有关此关系的信息存储在pg_depend+catalogue+table中。|3086890|连接关系是pg_depend.objid+->+pg_class.oid+WHERE+relkind+=+'S‘和pg_depend.refobjid+->+pg_class.oid+WHERE+relkind+=+'r’之间的链接，前者将序列链接到连接记录，后者将连接记录链接到所属关系(表)|3086891|此查询返回数据库中的所有sequence+->表依赖项。where子句将其过滤为仅包含自动生成的关系，这将其限制为仅显示由串行类型的列创建的序列。|3086892|WITH+fq_objects+AS+(SELECT+c.oid,n.nspname+%7C%7C+'.'+%7C%7Cc.relname+AS+fqname+,+
+++++++++++++++++++++++++++c.relkind,+c.relname+AS+relation+
++++++++++++++++++++FROM+pg_class+c+JOIN+pg_namespace+n+ON+n.oid+=+c.relnamespace+),

+++++sequences+AS+(SELECT+oid,fqname+FROM+fq_objects+WHERE+relkind+=+'S'),++
+++++tables++++AS+(SELECT+oid,+fqname+FROM+fq_objects+WHERE+relkind+=+'r'+)++
SELECT
+++++++s.fqname+AS+sequence,+
+++++++'->'+as+depends,+
+++++++t.fqname+AS+table+
FROM+
+++++pg_depend+d+JOIN+sequences+s+ON+s.oid+=+d.objid++
+++++++++++++++++JOIN+tables+t+ON+t.oid+=+d.refobjid++
WHERE+
+++++d.deptype+=+'a'+;|code-block|syntax|javascript|3086893|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/docs/8.4/static/sql-altersequence.html|1|http://www.postgresql.org/docs/8.4/static/catalog-pg-depend.html^0|0|5|N|0|0|0|0|0|0|B|P|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@$D|1A|E|1B|1|1C]]|A|$]]|$1|F|3|G|5|6|7|1D|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1E|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1F|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1G|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1H|8|@]|9|@$D|1I|E|1J|1|1K]]|A|$]]|$1|P|3|Q|5|6|7|1L|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1M|8|@]|9|@]|A|$]]|$1|T|3|U|5|V|7|1N|8|@]|9|@]|A|$W|X]]|$1|Y|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15]]|16|$5|11|12|13|A|$14|17]]]]

The relationship between automatically generated sequences ( such as those created for SERIAL columns ) and the parent table is modelled by the sequence owner attribute. 

You can modify this relationship using the OWNED BY clause of the <a href="http://www.postgresql.org/docs/8.4/static/sql-altersequence.html" rel="noreferrer">ALTER SEQUENCE commmand</a>

e.g. 
 ALTER SEQUENCE foo_id OWNED by foo_schema.foo_table 

to set it to be linked to the table foo_table

or
 ALTER SEQUENCE foo_id OWNED by NONE

to break the connection between the sequence and any table

The information about this relationship is stored in the <a href="http://www.postgresql.org/docs/8.4/static/catalog-pg-depend.html" rel="noreferrer">pg_depend catalogue table</a>. 

the joining relationship is the link between pg_depend.objid -> pg_class.oid WHERE relkind = 'S' - which links the sequence to the join record and then pg_depend.refobjid -> pg_class.oid WHERE relkind = 'r' , which links the join record to the owning relation ( table )

This query returns all the sequence -> table dependencies in a database. The where clause filters it to only include auto generated relationships, which restricts it to only display sequences created by SERIAL typed columns.

<pre><code>WITH fq_objects AS (SELECT c.oid,n.nspname || '.' ||c.relname AS fqname , 
 c.relkind, c.relname AS relation 
 FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace ),

 sequences AS (SELECT oid,fqname FROM fq_objects WHERE relkind = 'S'), 
 tables AS (SELECT oid, fqname FROM fq_objects WHERE relkind = 'r' ) 
SELECT
 s.fqname AS sequence, 
 '-&gt;' as depends, 
 t.fqname AS table 
FROM 
 pg_depend d JOIN sequences s ON s.oid = d.objid 
 JOIN tables t ON t.oid = d.refobjid 
WHERE 
 d.deptype = 'a' ;
</code></pre>

blocks|key|329962|text|有点像黑客，但试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|329963|select+'select+'''+%7C%7C+relname++%7C%7C+'''+as+sequence,+last_value+from+'++%7C%7C+relname+%7C%7C+'++union'
FROM+pg_catalog.pg_class+c
WHERE+c.relkind+IN+('S','');|code-block|syntax|javascript|329964|删除最后一个UNION并执行结果|329965|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Kind of a hack, but try this:
<pre><code>select 'select ''' || relname || ''' as sequence, last_value from ' || relname || ' union'
FROM pg_catalog.pg_class c
WHERE c.relkind IN ('S','');
</code></pre>
Remove the last UNION and execute the result

blocks|key|3300042|text|对前一个答案的改进：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3300043|select+string_agg('select+sequence_name,+last_value+from+'+%7C%7C+relname,+chr(13)+%7C%7C+'union'+%7C%7C+chr(13)+order+by+relname)+
from+pg_class+where+relkind+='S'|code-block|syntax|javascript|3300044|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Improvement of the previous answer:

<pre><code>select string_agg('select sequence_name, last_value from ' || relname, chr(13) || 'union' || chr(13) order by relname) 
from pg_class where relkind ='S'
</code></pre>

blocks|key|3086933|text|注意，从PostgreSQL+8.4开始，您可以通过以下方式获取有关数据库中使用的序列的所有信息：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086934|SELECT+*+FROM+information_schema.sequences;|code-block|syntax|javascript|3086935|3086936|由于我使用的是更高版本的PostgreSQL+(9.1)，并且到处都在搜索相同的答案，所以为了子孙后代和未来的搜索者，我添加了这个答案。|3086937|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|M|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|N|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|O|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|K|$]]

Note, that starting from PostgreSQL 8.4 you can get all information about sequences used in the database via:

<pre><code>SELECT * FROM information_schema.sequences;
</code></pre>

<hr>

Since I'm using a higher version of PostgreSQL (9.1), and was searching for same answer high and low, I added this answer for posterity's sake and for future searchers.

blocks|key|3086988|text|我知道这篇文章很老了，但我发现CMS的解决方案非常有用，因为我正在寻找一种自动将序列链接到表和列的方法，并想分享一下。pg_depend目录表的使用是关键。我将所做的扩展为：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3086989|WITH+fq_objects+AS+(SELECT+c.oid,n.nspname+%7C%7C+'.'+%7C%7Cc.relname+AS+fqname+,
+++++++++++++++++++++++++++c.relkind,+c.relname+AS+relation
++++++++++++++++++++FROM+pg_class+c+JOIN+pg_namespace+n+ON+n.oid+=+c.relnamespace+),

+++++sequences+AS+(SELECT+oid,fqname+FROM+fq_objects+WHERE+relkind+=+'S'),
+++++tables++++AS+(SELECT+oid,+fqname+FROM+fq_objects+WHERE+relkind+=+'r'+)
SELECT
+++++++s.fqname+AS+sequence,
+++++++'->'+as+depends,
+++++++t.fqname+AS+table,
+++++++a.attname+AS+column
FROM
+++++pg_depend+d+JOIN+sequences+s+ON+s.oid+=+d.objid
+++++++++++++++++JOIN+tables+t+ON+t.oid+=+d.refobjid
+++++++++++++++++JOIN+pg_attribute+a+ON+a.attrelid+=+d.refobjid+and+a.attnum+=+d.refobjsubid
WHERE
+++++d.deptype+=+'a'+;|code-block|syntax|javascript|3086990|此版本将列添加到返回的字段列表中。有了表名和列名，调用pg_set_serial_sequence可以轻松地确保数据库中的所有序列都被正确设置。例如：|3086991|CREATE+OR+REPLACE+FUNCTION+public.reset_sequence(tablename+text,+columnname+text)
+RETURNS+void
+LANGUAGE+plpgsql
AS+$function$
DECLARE
++++_sql+VARCHAR+:=+'';
BEGIN
++++_sql+:=+$$SELECT+setval(+pg_get_serial_sequence('$$+%7C%7C+tablename+%7C%7C+$$',+'$$+%7C%7C+columnname+%7C%7C+$$'),+(SELECT+COALESCE(MAX($$+%7C%7C+columnname+%7C%7C+$$),1)+FROM+$$+%7C%7C+tablename+%7C%7C+$$),+true)$$;
++++EXECUTE+_sql;
END;
$function$;|3086992|希望这对重置序列的人有帮助！|3086993|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/users/28532/cms|1|http://www.postgresql.org/docs/8.1/static/catalog-pg-depend.html|2|http://www.postgresql.org/docs/8.1/static/functions-info.html^0|F|3|0|1N|9|1|0|0|R|M|2|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]|$A|14|B|15|1|16]]|C|$]]|$1|D|3|E|5|F|7|17|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|K|3|L|5|F|7|1C|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|1D|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|1E|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]|Y|$5|R|S|T|C|$U|Z]]]]

I know this post is pretty old, but I found the solution by <a href="https://stackoverflow.com/users/28532/cms">CMS</a> to be very useful as I was looking for an automated way to link a sequence to the table AND column, and wanted to share. The use of <a href="http://www.postgresql.org/docs/8.1/static/catalog-pg-depend.html" rel="nofollow noreferrer">pg_depend</a> catalog table was the key. I expanded what was done to:

<pre><code>WITH fq_objects AS (SELECT c.oid,n.nspname || '.' ||c.relname AS fqname ,
 c.relkind, c.relname AS relation
 FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace ),

 sequences AS (SELECT oid,fqname FROM fq_objects WHERE relkind = 'S'),
 tables AS (SELECT oid, fqname FROM fq_objects WHERE relkind = 'r' )
SELECT
 s.fqname AS sequence,
 '-&gt;' as depends,
 t.fqname AS table,
 a.attname AS column
FROM
 pg_depend d JOIN sequences s ON s.oid = d.objid
 JOIN tables t ON t.oid = d.refobjid
 JOIN pg_attribute a ON a.attrelid = d.refobjid and a.attnum = d.refobjsubid
WHERE
 d.deptype = 'a' ;
</code></pre>

This version adds column to the list of fields returned. With both the table name and the column name in hand, a call to <a href="http://www.postgresql.org/docs/8.1/static/functions-info.html" rel="nofollow noreferrer">pg_set_serial_sequence</a> makes it easy to ensure that all sequences in the database are set correctly. For example:

<pre><code>CREATE OR REPLACE FUNCTION public.reset_sequence(tablename text, columnname text)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
DECLARE
 _sql VARCHAR := '';
BEGIN
 _sql := $$SELECT setval( pg_get_serial_sequence('$$ || tablename || $$', '$$ || columnname || $$'), (SELECT COALESCE(MAX($$ || columnname || $$),1) FROM $$ || tablename || $$), true)$$;
 EXECUTE _sql;
END;
$function$;
</code></pre>

Hope this helps someone with resetting sequences!

blocks|key|3087006|text|此语句列出与每个序列关联的表和列：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3087007|代码：|3087008|++++SELECT+t.relname+as+related_table,+
+++++++++++a.attname+as+related_column,
+++++++++++s.relname+as+sequence_name
++++FROM+pg_class+s+
++++++JOIN+pg_depend+d+ON+d.objid+=+s.oid+
++++++JOIN+pg_class+t+ON+d.objid+=+s.oid+AND+d.refobjid+=+t.oid+
++++++JOIN+pg_attribute+a+ON+(d.refobjid,+d.refobjsubid)+=+(a.attrelid,+a.attnum)
++++++JOIN+pg_namespace+n+ON+n.oid+=+s.relnamespace+
++++WHERE+s.relkind+++++=+'S'+

++AND+n.nspname+++++=+'public'|code-block|syntax|javascript|3087009|更多信息请查看此处link+to+answer|offset|length|3087010|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dbforums.com/showthread.php?1667561-How-to-list-sequences-and-the-columns-by-SQL&s=7c5a84b7489cc1d0f329262b4d4b83b8&p=6508623#post6508623^0|0|0|0|9|E|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

This statement lists the table and column that is associated with each sequence:

Code:

<pre><code> SELECT t.relname as related_table, 
 a.attname as related_column,
 s.relname as sequence_name
 FROM pg_class s 
 JOIN pg_depend d ON d.objid = s.oid 
 JOIN pg_class t ON d.objid = s.oid AND d.refobjid = t.oid 
 JOIN pg_attribute a ON (d.refobjid, d.refobjsubid) = (a.attrelid, a.attnum)
 JOIN pg_namespace n ON n.oid = s.relnamespace 
 WHERE s.relkind = 'S' 

 AND n.nspname = 'public'
</code></pre>

more see here <a href="http://www.dbforums.com/showthread.php?1667561-How-to-list-sequences-and-the-columns-by-SQL&amp;s=7c5a84b7489cc1d0f329262b4d4b83b8&amp;p=6508623#post6508623" rel="nofollow">link to answer</a>

blocks|key|3087023|text|谢谢你的帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3087024|下面是pl/pgsql函数，用于更新数据库的每个序列。|3087025|---------------------------------------------------------------------------------------------------------
---+Nom+:+reset_sequence
---+Description+:+Générique+-+met+à+jour+les+séquences+au+max+de+l'identifiant
---------------------------------------------------------------------------------------------------------

CREATE+OR+REPLACE+FUNCTION+reset_sequence()+RETURNS+void+AS+
$BODY$
DECLARE+_sql+VARCHAR+:=+'';
DECLARE+result+threecol%25rowtype;+
BEGIN
FOR+result+IN+
WITH+fq_objects+AS+(SELECT+c.oid,n.nspname+%7C%7C+'.'+%7C%7Cc.relname+AS+fqname+,c.relkind,+c.relname+AS+relation+FROM+pg_class+c+JOIN+pg_namespace+n+ON+n.oid+=+c.relnamespace+),
++++sequences+AS+(SELECT+oid,fqname+FROM+fq_objects+WHERE+relkind+=+'S'),
++++tables++++AS+(SELECT+oid,+fqname+FROM+fq_objects+WHERE+relkind+=+'r'+)
SELECT
+++++++s.fqname+AS+sequence,
+++++++t.fqname+AS+table,
+++++++a.attname+AS+column
FROM
+++++pg_depend+d+JOIN+sequences+s+ON+s.oid+=+d.objid
+++++++++++++++++JOIN+tables+t+ON+t.oid+=+d.refobjid
+++++++++++++++++JOIN+pg_attribute+a+ON+a.attrelid+=+d.refobjid+and+a.attnum+=+d.refobjsubid
WHERE
+++++d.deptype+=+'a'+
LOOP
+++++EXECUTE+'SELECT+setval('''%7C%7Cresult.col1%7C%7C''',+COALESCE((SELECT+MAX('%7C%7Cresult.col3%7C%7C')%2B1+FROM+'%7C%7Cresult.col2%7C%7C'),+1),+false);';
END+LOOP;
END;$BODY$+LANGUAGE+plpgsql;

SELECT+*+FROM+reset_sequence();|code-block|syntax|javascript|3087026|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Thanks for your help. 

Here is the pl/pgsql function which update each sequence of a database.

<pre><code>---------------------------------------------------------------------------------------------------------
--- Nom : reset_sequence
--- Description : Générique - met à jour les séquences au max de l'identifiant
---------------------------------------------------------------------------------------------------------

CREATE OR REPLACE FUNCTION reset_sequence() RETURNS void AS 
$BODY$
DECLARE _sql VARCHAR := '';
DECLARE result threecol%rowtype; 
BEGIN
FOR result IN 
WITH fq_objects AS (SELECT c.oid,n.nspname || '.' ||c.relname AS fqname ,c.relkind, c.relname AS relation FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace ),
 sequences AS (SELECT oid,fqname FROM fq_objects WHERE relkind = 'S'),
 tables AS (SELECT oid, fqname FROM fq_objects WHERE relkind = 'r' )
SELECT
 s.fqname AS sequence,
 t.fqname AS table,
 a.attname AS column
FROM
 pg_depend d JOIN sequences s ON s.oid = d.objid
 JOIN tables t ON t.oid = d.refobjid
 JOIN pg_attribute a ON a.attrelid = d.refobjid and a.attnum = d.refobjsubid
WHERE
 d.deptype = 'a' 
LOOP
 EXECUTE 'SELECT setval('''||result.col1||''', COALESCE((SELECT MAX('||result.col3||')+1 FROM '||result.col2||'), 1), false);';
END LOOP;
END;$BODY$ LANGUAGE plpgsql;

SELECT * FROM reset_sequence();
</code></pre>

blocks|key|332213|text|序列信息:最大值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|332214|SELECT+*+FROM+information_schema.sequences;|offset|length|style|CODE|332215|序列信息:最后一个值|332216|SELECT+*+FROM+<sequence_name>|332217|entityMap^0|0|0|17|0|0|0|T|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

sequence info : max value

<code>SELECT * FROM information_schema.sequences;
</code>

sequence info : last value

<code>SELECT * FROM &lt;sequence_name&gt;
</code>

blocks|key|330017|text|下面是另一个序列名旁边的模式名|type|unstyled|depth|inlineStyleRanges|entityRanges|data|330018|select+nspname,relname+from+pg_class+c+join+pg_namespace+n+on+c.relnamespace=n.oid+where+relkind+=+'S'+order+by+nspname|code-block|syntax|javascript|330019|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here is another one which has the schema name beside the sequence name

<pre><code>select nspname,relname from pg_class c join pg_namespace n on c.relnamespace=n.oid where relkind = 'S' order by nspname
</code></pre>

blocks|key|3087083|text|通过解析DEFAULT子句，获取每个表中每一列的序列。此方法提供有关哪些列序列链接到的信息，并且不使用对于某些序列可能不存在的dependencies。即使是pg_get_serial_sequence(sch.nspname%7C%7C'.'%7C%7Ctbl.relname,+col.attname)函数也没有为我找到所有的序列！|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|3087084|解决方案：|3087085|SELECT
++++seq_sch.nspname++AS+sequence_schema
++,+seq.relname++++++AS+sequence_name
++,+seq_use."schema"+AS+used_in_schema
++,+seq_use."table"++AS+used_in_table
++,+seq_use."column"+AS+used_in_column
FROM+pg_class+seq
++INNER+JOIN+pg_namespace+seq_sch+ON+seq_sch.oid+=+seq.relnamespace
++LEFT+JOIN+(
++++++++++++++SELECT
++++++++++++++++++sch.nspname+AS+"schema"
++++++++++++++++,+tbl.relname+AS+"table"
++++++++++++++++,+col.attname+AS+"column"
++++++++++++++++,+regexp_split_to_array(
++++++++++++++++++++++TRIM(LEADING+'nextval('''+FROM
+++++++++++++++++++++++++++TRIM(TRAILING+'''::regclass)'+FROM
++++++++++++++++++++++++++++++++pg_get_expr(def.adbin,+tbl.oid,+TRUE)
+++++++++++++++++++++++++++)
++++++++++++++++++++++)
++++++++++++++++++++++,+'\.'
++++++++++++++++++)+++++++++++AS+column_sequence
++++++++++++++FROM+pg_class+tbl+--the+table
++++++++++++++++INNER+JOIN+pg_namespace+sch+ON+sch.oid+=+tbl.relnamespace
++++++++++++++++--schema
++++++++++++++++INNER+JOIN+pg_attribute+col+ON+col.attrelid+=+tbl.oid
++++++++++++++++--columns
++++++++++++++++INNER+JOIN+pg_attrdef+def+ON+(def.adrelid+=+tbl.oid+AND+def.adnum+=+col.attnum)+--default+values+for+columns
++++++++++++++WHERE+tbl.relkind+=+'r'+--regular+relations+(tables)+only
++++++++++++++++++++AND+col.attnum+>+0+--regular+columns+only
++++++++++++++++++++AND+def.adsrc+LIKE+'nextval(%25)'+--sequences+only
++++++++++++)+seq_use+ON+(seq_use.column_sequence+[1]+=+seq_sch.nspname+AND+seq_use.column_sequence+[2]+=+seq.relname)
WHERE+seq.relkind+=+'S'+--sequences+only
ORDER+BY+sequence_schema,+sequence_name;|code-block|syntax|javascript|3087086|请注意，1个序列可以在多个表中使用，因此它可以在此处的多行中列出。|3087087|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/11630002/7573844^0|17|39|27|1U|1R|C|0|0|0|5|0|0|0|X|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]|$9|10|A|11|B|D]]|E|@$9|12|A|13|1|14]]|F|$]]|$1|G|3|H|5|6|7|15|8|@$9|16|A|17|B|C]]|E|@]|F|$]]|$1|I|3|J|5|K|7|18|8|@]|E|@]|F|$L|M]]|$1|N|3|O|5|6|7|19|8|@$9|1A|A|1B|B|C]]|E|@]|F|$]]|$1|P|3|-4|5|6|7|1C|8|@]|E|@]|F|$]]]|Q|$R|$5|S|T|U|F|$V|W]]]]

Get sequences by each column of each table via parsing of DEFAULT clause. This method provides info about to which column sequences are linked and does not use <a href="https://stackoverflow.com/a/11630002/7573844">dependencies</a> which may not exist for some sequences. Even <code>pg_get_serial_sequence(sch.nspname||'.'||tbl.relname, col.attname)</code> function found not all sequences for me!

Solution:

<pre><code>SELECT
 seq_sch.nspname AS sequence_schema
 , seq.relname AS sequence_name
 , seq_use."schema" AS used_in_schema
 , seq_use."table" AS used_in_table
 , seq_use."column" AS used_in_column
FROM pg_class seq
 INNER JOIN pg_namespace seq_sch ON seq_sch.oid = seq.relnamespace
 LEFT JOIN (
 SELECT
 sch.nspname AS "schema"
 , tbl.relname AS "table"
 , col.attname AS "column"
 , regexp_split_to_array(
 TRIM(LEADING 'nextval(''' FROM
 TRIM(TRAILING '''::regclass)' FROM
 pg_get_expr(def.adbin, tbl.oid, TRUE)
 )
 )
 , '\.'
 ) AS column_sequence
 FROM pg_class tbl --the table
 INNER JOIN pg_namespace sch ON sch.oid = tbl.relnamespace
 --schema
 INNER JOIN pg_attribute col ON col.attrelid = tbl.oid
 --columns
 INNER JOIN pg_attrdef def ON (def.adrelid = tbl.oid AND def.adnum = col.attnum) --default values for columns
 WHERE tbl.relkind = 'r' --regular relations (tables) only
 AND col.attnum &gt; 0 --regular columns only
 AND def.adsrc LIKE 'nextval(%)' --sequences only
 ) seq_use ON (seq_use.column_sequence [1] = seq_sch.nspname AND seq_use.column_sequence [2] = seq.relname)
WHERE seq.relkind = 'S' --sequences only
ORDER BY sequence_schema, sequence_name;
</code></pre>

Note that 1 sequence can be used in multiple tables, so it can be listed in multiple rows here.

blocks|key|3300242|text|此函数显示每个序列的last_value。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3300243|它输出一个两列的表，其中显示了序列名称以及它最后生成的值。|3300244|drop+function+if+exists+public.show_sequence_stats();
CREATE+OR+REPLACE+FUNCTION+public.show_sequence_stats()
++++RETURNS+TABLE(tablename+text,+last_value+bigint)+
++++LANGUAGE+'plpgsql'
++++COST+100
++++VOLATILE+
++++ROWS+1000
AS+$BODY$
declare+r+refcursor;+rec+record;+dynamic_query+varchar;
++++++++BEGIN
++++++++++++dynamic_query='select+tablename,last_value+from+(';
++++++++++++open+r+for+execute+'select+nspname,relname+from+pg_class+c+join+pg_namespace+n+on+c.relnamespace=n.oid+where+relkind+=+''S''+order+by+nspname';+
++++++++++++fetch+next+from+r+into+rec;
++++++++++++while+found+
++++++++++++loop
++++++++++++++++dynamic_query=dynamic_query+%7C%7C+'select+'''%7C%7C+rec.nspname+%7C%7C+'.'+%7C%7C+rec.relname+%7C%7C'''+"tablename",last_value+from+'+%7C%7C+rec.nspname+%7C%7C+'.'+%7C%7C+rec.relname+%7C%7C+'+union+all+';
++++++++++++++++fetch+next+from+r+into+rec;+
++++++++++++end+loop;
++++++++++++close+r;+
++++++++++++dynamic_query=rtrim(dynamic_query,'union+all')+%7C%7C+')+x+order+by+last_value+desc;';
++++++++++++return+query+execute+dynamic_query;
++++++++END;
$BODY$;

select+*+from+show_sequence_stats();|code-block|syntax|javascript|3300245|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This function shows the last_value of each sequence.

It outputs a 2 columns table that says the sequence name plus it's last generated value.

<pre><code>drop function if exists public.show_sequence_stats();
CREATE OR REPLACE FUNCTION public.show_sequence_stats()
 RETURNS TABLE(tablename text, last_value bigint) 
 LANGUAGE 'plpgsql'
 COST 100
 VOLATILE 
 ROWS 1000
AS $BODY$
declare r refcursor; rec record; dynamic_query varchar;
 BEGIN
 dynamic_query='select tablename,last_value from (';
 open r for execute 'select nspname,relname from pg_class c join pg_namespace n on c.relnamespace=n.oid where relkind = ''S'' order by nspname'; 
 fetch next from r into rec;
 while found 
 loop
 dynamic_query=dynamic_query || 'select '''|| rec.nspname || '.' || rec.relname ||''' "tablename",last_value from ' || rec.nspname || '.' || rec.relname || ' union all ';
 fetch next from r into rec; 
 end loop;
 close r; 
 dynamic_query=rtrim(dynamic_query,'union all') || ') x order by last_value desc;';
 return query execute dynamic_query;
 END;
$BODY$;

select * from show_sequence_stats();
</code></pre>

blocks|key|3300264|text|假设在这篇post+https://stackoverflow.com/a/46721603/653539中声明了exec()函数，可以使用单个查询来获取序列及其最后一个值：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3300265|select+s.sequence_schema,+s.sequence_name,
++(select+*+from+exec('select+last_value+from+'+%7C%7C+s.sequence_schema+%7C%7C+'.'+%7C%7C+s.sequence_name)+as+e(lv+bigint))+last_value
from+information_schema.sequences+s|code-block|syntax|javascript|3300266|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/46721603/653539^0|1L|6|A|17|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Assuming <code>exec()</code> function declared in this post <a href="https://stackoverflow.com/a/46721603/653539">https://stackoverflow.com/a/46721603/653539</a> , sequences together with their last values can be fetched using single query:

<pre><code>select s.sequence_schema, s.sequence_name,
 (select * from exec('select last_value from ' || s.sequence_schema || '.' || s.sequence_name) as e(lv bigint)) last_value
from information_schema.sequences s
</code></pre>

blocks|key|330038|text|select+sequence_name,+(xpath('/row/last_value/text()',+xml_count))[1]::text::int+as+last_value
from+(
++++select+sequence_schema,
++++++++++++sequence_name,+++++++++
++++++++++++query_to_xml(format('select+last_value+from+%25I.%25I',+sequence_schema,+sequence_name),+false,+true,+'')+as+xml_count
++++from+information_schema.sequences
++++where+sequence_schema+=+'public'
)+new_table+order+by+last_value+desc;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|330039|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select sequence_name, (xpath('/row/last_value/text()', xml_count))[1]::text::int as last_value
from (
 select sequence_schema,
 sequence_name, 
 query_to_xml(format('select last_value from %I.%I', sequence_schema, sequence_name), false, true, '') as xml_count
 from information_schema.sequences
 where sequence_schema = 'public'
) new_table order by last_value desc;
</code></pre>

blocks|key|3300280|text|以下是如何使用psql获取所有序列及其last_value的列表的示例|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3300281|psql+-U+<username>+-d+<database>+-t+-c+"SELECT+'SELECT+'''+%7C%7C+c.relname+%7C%7C+'''+as+sequence_name,+last_value+FROM+'+%7C%7C+c.relname+%7C%7C+';'+FROM+pg_class+c+WHERE+(c.relkind+=+'S')"+%7C+psql+-U+<username>+-d+<database>+-t|3300282|entityMap^0|7|4|J|A|0|0|5X|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

Here is an example how to use <code>psql</code> to get a list of all sequences with their <code>last_value</code>:

<code>psql -U &lt;username&gt; -d &lt;database&gt; -t -c "SELECT 'SELECT ''' || c.relname || ''' as sequence_name, last_value FROM ' || c.relname || ';' FROM pg_class c WHERE (c.relkind = 'S')" | psql -U &lt;username&gt; -d &lt;database&gt; -t</code>

blocks|key|329028|text|我知道问题是关于postgresql版本8的，但我在这里为想要获取版本10和更高版本中的序列的人写了这个简单的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|329029|您可以使用下面的查询|329030|select+*+from+pg_sequences|code-block|syntax|javascript|329031|view-pg-sequences|offset|length|329032|entityMap|0|LINK|mutability|MUTABLE|url|https://www.postgresql.org/docs/10/view-pg-sequences.html^0|0|0|0|0|H|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

I know the question was about postgresql version 8 but I wrote this simple way here for people who want to get sequences in version 10 and upper
you can use the bellow query
<pre><code>select * from pg_sequences
</code></pre>
<a href="https://www.postgresql.org/docs/10/view-pg-sequences.html" rel="noreferrer">view-pg-sequences</a>

blocks|key|329037|text|获取所有序列：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|329038|select+*+from+pg_sequences;|code-block|syntax|javascript|329039|PSQL：|329040|\ds
\ds%2B
\ds+*actor*|329041|\ds+*actor*将获取序列名称中包含参与者字符的所有序列。|offset|length|style|CODE|329042|entityMap^0|0|0|0|0|0|B|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Get all sequence:
<pre><code>select * from pg_sequences;
</code></pre>
PSQL:
<pre><code>\ds
\ds+
\ds *actor*
</code></pre>
<code>\ds *actor*</code> will get all the sequence that sequence name contains actor characters.

I'm converting a db from postgres to mysql. 

Since i cannot find a tool that does the trick itself, i'm going to convert all postgres sequences to autoincrement ids in mysql with autoincrement value.

So, how can i list all sequences in a Postgres DB (8.1 version) with information about the table in which it's used, the next value etc with a SQL query?

Be aware that i can't use the <code>information_schema.sequences</code> view in the 8.4 release.

List all sequences in a Postgres db 8.1 with SQL

PostgreSQL

数据库

我正在将一个数据库从postgres转换到mysql。由于我找不到一个能自动完成此任务的工具，因此我将在mysql中将所有postgres序列转换为具有自动增量值的自动增量i。那么，如何使用查询列出Postgres DB (SQL8.1版本)中的所有序列以及使用它的表、下一个值等信息？请注意，我不能在8.4版本中使用i...

问使用SQL列出Postgres数据库8.1中的所有序列
EN

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用SQL列出Postgres数据库8.1中的所有序列EN