Re: How to use pg_restore with *.sql file?
От
Andre Lopes
Тема
Re: How to use pg_restore with *.sql file?
Дата
Msg-id
AANLkTi=9WwYLonrZTGaivwJV0AXMjcHD0v79goXdSDo0@mail.gmail.com
Ответ на
Re: How to use pg_restore with *.sql file? (Scott Marlowe)
Список
Дерево обсуждения
How to use pg_restore with *.sql file? Andre Lopes <lopes80andre@gmail.com>
Re: How to use pg_restore with *.sql file? Scott Marlowe <scott.marlowe@gmail.com>
Re: How to use pg_restore with *.sql file? Andre Lopes <lopes80andre@gmail.com>
Re: How to use pg_restore with *.sql file? Dmitriy Igrishin <dmitigr@gmail.com>
Thanks a lot! It works.
On Sat, Sep 25, 2010 at 1:23 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Sat, Sep 25, 2010 at 6:19 AM, Andre Lopes <lopes80andre@gmail.com> wrote:Don't.
> 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?
Just use psql with plain sql dumps:
psql databasename -f exportfilename.sql
В списке pgsql-general по дате отправления
