On Sat, Sep 25, 2010 at 6:19 AM, Andre Lopes <lopes80andre@xxxxxxxxx> wrote: > Hi, > > I have generate an *.sql file with the command: > > [quote] > pg_dump -a --inserts databasename > exportfilename.sql > [/quote] > > How can I use the pg_restore to import the data to the database? Don't. Just use psql with plain sql dumps: psql databasename -f exportfilename.sql -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general