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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general