On 03/19/2015 08:43 AM, "Leonardo M. Ramé" wrote:

Hi, I'm creating a database dump excluding one table and found only the
sequences created implicitly (using serial type) are created when I
restore the dump.

The command I use is: pg_dump -T table_to_be_excluded mydb

I understand all related objects to the table to be excluded are not
dumpled, but why I don't get any CREATE SEQUENCE command in my dump?.


What version of Postgres?

If I follow you have CREATEd sequence(s) using CREATE SEQUENCE and they do not show up in the dump file?

It works for me here on 9.3.


--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to