Re: Importing data in postgres from .sql file

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

In response to

Browse pgsql-php by date

  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: