From: | Gavin Sherry <swm(at)alcove(dot)com(dot)au> |
---|---|
To: | Vaughan Bezuidenhout <vaughan(at)ibsoft(dot)co(dot)za> |
Cc: | sydpug(at)postgresql(dot)org |
Subject: | Re: Question. |
Date: | 2006-08-22 23:07:57 |
Message-ID: | Pine.LNX.4.58.0608230901590.7443@linuxworld.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sydpug |
Hi Vaughan,
On Tue, 22 Aug 2006, 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
I'm not familiar with VB6, but you can use SQL to discover this. You can
use the information schema to discover this:
http://www.postgresql.org/docs/8.1/static/information-schema.html
The nice thing about information schema is that it is specified by ANSI
SQL and should work in the same way on DB2 and MySQL soon as well, I
think.
Alternatively, you can start psql with the -E flag, run \d and copy the
SQL.
> 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.
>
> Your help will be appreciated.
FWIW, this list is actually about the Sydney PostgreSQL Users Group. The
kind of question you have is usually discussed on pgsql-general:
Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Smith | 2006-08-23 00:37:22 | Re: Question. |
Previous Message | Vaughan Bezuidenhout | 2006-08-22 16:30:41 | Question. |