postgres import
am 31.10.2006 09:30:50 von Antonios Katsikadamos--0-1680858453-1162283450=:5072
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi all,
=20
=20
sorry again for the trouble. I have a small problem in postgres, I have=
a .sql file ( db dump ) and i want to import it in postgres on linux.=20
=20
=20
does anyone know how to do it?
=20
Thnx a lot for your time
=09
---------------------------------
Get your email and more, right on the new Yahoo.com=20
--0-1680858453-1162283450=:5072
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
n for the trouble. I have a small problem in postgres, I have a .sql file=
( db dump ) and i want to import it in postgres on linux. div>
do it?
&#=
32;
Get your email and more, right on the ..rd.yahoo.com/evt=3D42973/*http://www.yahoo.com/preview"> new Yahoo.com a>=20
--0-1680858453-1162283450=:5072--
Re: postgres import
am 31.10.2006 09:35:10 von Achilleus MantziosÓôéò Ôñßô=E7 31 Ïêôþâñéï=F2 2006 10:30, =EF=
/=E7 Antonios Katsikadamos Ýãñáøå:
> Hi all,
>
>
> sorry again for the trouble. I have a small problem in postgres, I have=
a
> .sql file ( db dump ) and i want to import it in postgres on linux.
>
% psql
\i
>
> does anyone know how to do it?
>
> Thnx a lot for your time
>
>
> ---------------------------------
> Get your email and more, right on the new Yahoo.com
--=20
Achilleas Mantzios
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Re: postgres import
am 31.10.2006 11:49:50 von Adam RadlowskiAchilleas informed You very good. But if Your SQL file comes from other
DBMS, like MySQL, You have to a little bit to edit this file, becouse
sometimes in those files are used "slangs" characteristical for specific
DBMS.
If You have SQL file genarated with "pg_dump", You have to be sure, that
all needed roles (users, groups) are defined in Your destination
database, when in SQL file You have GRANT or REVOKE.
Greetings
Adam
Antonios Katsikadamos wrote:
> Hi all,
>
>
> sorry again for the trouble. I have a small problem in postgres, I
> have a .sql file ( db dump ) and i want to import it in postgres on
> linux.
>
>
> does anyone know how to do it?
>
> Thnx a lot for your time
>
> Get your email and more, right on the new Yahoo.com
>
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly