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(dot)klaver(at)aklaver(dot)com