| From: | Adam Radlowski <adamr(at)informatyka(dot)gdansk(dot)pl> |
|---|---|
| To: | Antonios Katsikadamos <antonioskatsikadamos(at)yahoo(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgres import |
| Date: | 2006-10-31 10:49:50 |
| Message-ID: | 45472A4E.8050206@informatyka.gdansk.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nineday | 2006-10-31 11:05:58 | I have a question about Database management |
| Previous Message | Moiz Kothari | 2006-10-31 09:42:08 | Re: 100% failover + replication solution |