MySQL to Postgres.
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!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo
Did you try looking it up on Google newsgroups? It usually gives you the answer. Prabu Subroto wrote:
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!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo
-- To unsubscribe, email: suse-programming-e-unsubscribe@suse.com For additional commands, email: suse-programming-e-help@suse.com Archives can be found at: http://lists.suse.com/archive/suse-programming-e
participants (2)
-
Craig Steffler
-
Prabu Subroto