pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres import
3+ messages / 3 participants
[nested] [flat]
* postgres import
@ 2006-10-31 08:30 Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
2006-10-31 08:35 ` Re: postgres import Achilleas Mantzios <achill@matrix.gatewaynet.com>
2006-10-31 10:49 ` Re: postgres import Adam Radlowski <adamr@informatyka.gdansk.pl>
0 siblings, 2 replies; 3+ messages in thread
From: Antonios Katsikadamos @ 2006-10-31 08:30 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres import
2006-10-31 08:30 postgres import Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
@ 2006-10-31 08:35 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 0 replies; 3+ messages in thread
From: Achilleas Mantzios @ 2006-10-31 08:35 UTC (permalink / raw)
To: pgsql-admin
Óôéò Ôñßôç 31 Ïêôþâñéïò 2006 10:30, ï/ç 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 <file>.sql
>
> does anyone know how to do it?
>
> Thnx a lot for your time
>
>
> ---------------------------------
> Get your email and more, right on the new Yahoo.com
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres import
2006-10-31 08:30 postgres import Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
@ 2006-10-31 10:49 ` Adam Radlowski <adamr@informatyka.gdansk.pl>
1 sibling, 0 replies; 3+ messages in thread
From: Adam Radlowski @ 2006-10-31 10:49 UTC (permalink / raw)
To: Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>; +Cc: pgsql-admin
Achilleas 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
> <http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview;
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-10-31 10:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-31 08:30 postgres import Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
2006-10-31 08:35 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2006-10-31 10:49 ` Adam Radlowski <adamr@informatyka.gdansk.pl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox