Importing data in postgres from .sql file
Archana K N <[email protected]> Wed, 5 Sep 2012 12:49:44 +0530
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <CACa6=i2LzUkPaCFz=Jsw7fL5p_GZzWZZFzjPuizV8yd_ONTqug@mail.gmail.com> |
--f46d043086faf1ff2c04c8ef32d4
Content-Type: text/plain; charset=ISO-8859-1
Hi,
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.
--
-------------------
regards
archana
--------------------
--
-------------------
regards
archana
--------------------
--f46d043086faf1ff2c04c8ef32d4
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<br><br><div class=3D"gmail_quote"><br><br><br>Hi,<br><br>=A0=A0=A0 I used =
the "Export" option in the phpPgAdmin for exporting certain datab=
ase and i got a zip file with .sql file inside it. I dont know how to impor=
t it back to postgres as i dont see any option for importing. I am a bit co=
nfused with the psql command prompt. Can anyone please help me to import th=
e data back.<span class=3D"HOEnZb"><font color=3D"#888888"><br>
=A0=A0=A0=A0 <br clear=3D"all"><br>-- <br>-------------------<br>regards<br=
>archana<br>--------------------<br>
</font></span></div><br><br clear=3D"all"><br>-- <br>-------------------<br=
>regards<br>archana<br>--------------------<br>
--f46d043086faf1ff2c04c8ef32d4--