Thanks a lot! It works.
On Sat, Sep 25, 2010 at 1:23 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
> On Sat, Sep 25, 2010 at 6:19 AM, Andre Lopes <lopes80andre(at)gmail(dot)com>
> 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
>