From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Archana K N <archanakknn(at)gmail(dot)com> |
Cc: | PostgreSQLPHP PostgreSQLPHP <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: Importing data in postgres from .sql file |
Date: | 2012-09-05 11:42:34 |
Message-ID: | CAFcNs+obYoM0WPGb=BohPG3RHVHoyqWsb9MkVxUHN6v=PcTUCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
2012/9/5 Archana K N <archanakknn(at)gmail(dot)com>
>
> I used the "Export" option in the phpPgAdmin for exporting certain
> database and i got a zip file with .sql file inside it. I dont know how to
> import it back to postgres as i dont see any option for importing. I am a
> bit confused with the psql command prompt. Can anyone please help me to
> import the data back.
>
>
Hi,
You can use the psql command line:
$ unzip -c name_of_your_file.zip | psql -U postgres name_of_your_database
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
From | Date | Subject | |
---|---|---|---|
Next Message | hatem | 2012-10-10 04:40:26 | imprtant please read and deliver to who may concern (updated copy) |
Previous Message | Archana K N | 2012-09-05 10:31:48 | Re: |