From: | Prabu Subroto <prabu_subroto(at)yahoo(dot)com> |
---|---|
To: | Postgres General Milis <pgsql-general(at)postgresql(dot)org> |
Subject: | MySQL to Postgres. |
Date: | 2004-06-17 14:45:49 |
Message-ID: | 20040617144549.26383.qmail@web41801.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear my friends...
I am planning to migrate my database from MySQL to
Postgres since the MySQL does not have subquery except
it 4.1. And I can not wait until the 4.1 stable
version released and included in SuSE distro.
I did mysqldump (into a file, basisdata.txt) and I am
going to do its query qith pgaccess or pgsql.
I tried to import the database (do the query of
basisdata.txt) with pgaccess but I couldn't. Because
pgaccess support only one by one importing table.
I tried with pgsql, look for the suitable command to
do that with "\h" in the pgsql console. But I could
not find the suitable command.
Anybody would be so nice to tell me how I can do that
with pgaccess and/or pgsql ?
Thank you very much in advance.
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Fitzpatrick | 2004-06-17 14:56:45 | Re: Database accesss using plperl |
Previous Message | Jeff | 2004-06-17 13:37:29 | Re: Visual Explain |