Postgres Pro
Downloads
Home   >   mailing lists

Re: How to import *.sql file to postgresql database - Mailing list pgsql-general

From Osvaldo Kussama
Subject Re: How to import *.sql file to postgresql database
Date
Msg-id AANLkTilThGQrmF-h5Td7myoFgrfZpexbvxrFgDbPPzBH@mail.gmail.com
Whole thread Raw
In response to How to import *.sql file to postgresql database  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view 
2010/7/18 Andre Lopes <lopes80andre@gmail.com>:
> Hi,
>
> I have a DUMP file with INSERT's commands. I need to import this data to
> postgresql database with the "psql" command.
>
> How can I do this task?
>
> Best Regards,
>


From manual [1] 24.1.1. Restoring the dump:
psql dbname < infile

Osvaldo
[1] http://www.postgresql.org/docs/current/interactive/backup-dump.html#BACKUP-DUMP-RESTORE

pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: Re: How to import *.sql file to postgresql database
Next
From: John Gage
Date:
Subject: Differences between Postgres and MySql