Skip site navigation (1) Skip section navigation (2)

Re: Question.

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: (view raw, whole thread or download thread mbox)
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:

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

Alternatively, you can start psql with the -E flag, run \d and copy the

> 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:


In response to

  • Question. at 2006-08-22 16:30:41 from Vaughan Bezuidenhout

sydpug by date

Next:From: Chris SmithDate: 2006-08-23 00:37:22
Subject: Re: Question.
Previous:From: Vaughan BezuidenhoutDate: 2006-08-22 16:30:41
Subject: Question.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group