Re: Question.

Vaughan Bezuidenhout wrote:
> Hi There,
>
> I develop software and have decided to try postgresql as a db. Can
> anyone please advise me om how to read the postgresql schema with vb6. I
> need to convert existing tables in MySQL to Postgresql. I need to
> develop this migration tool myself to use elsewhere, so I need to read
> the MySSQL schema(which I can do) and port the structure to Postgresql.
> Thereafter I will convert each field of each record.

You could look at how phppgadmin (http://phppgadmin.sf.net) does it.

You could also look at using a script to do the conversion for you:
http://pgfoundry.org/projects/my2postgres/

and this may also help out in the short term:
http://pgfoundry.org/projects/mysqlcompat/

You'd probably get better responses on one of the postgresql lists:
http://www.postgresql.org/community/lists/ (probably -general)

--
Best Regards,

Chris Smith
PHP Product Manager
Interspire - The World's Best Selling Webware
http://www.interspire.com