Re: How to use pg_restore with *.sql file?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to use pg_restore with *.sql file?
Date: 2010-09-25 12:23:00
Message-ID: AANLkTi=AqmWrUR4f8+EfCHzP+QrL1=unRLZp_jX7SoqF@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-09-25 12:24:23 Re: How to use pg_restore with *.sql file?
Previous Message Andre Lopes 2010-09-25 12:19:29 How to use pg_restore with *.sql file?