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

database structure / generic client apps

From: "Bob Lapique" <lapique(at)ifrance(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: database structure / generic client apps
Date: 2002-06-07 16:52:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
I am to write an interface to a database with 38 tables and will have to
write others in the future.

Instead of creating a form manually for each table, I would like to
create them dynamically (Trolltech's Qt). Same with queries. But to do
so, I need to know the structure of the database at RUN TIME.

The number of fields and their type is given by libpq++. ( Where is the
definition of the Oid number returned ? ) >> OK  :)

BUT I could not find out how to know if a table has a FOREIGN KEY
constraint on some other table. And what is its PRIMARY KEY. Yet,
PgAdmin manages to do that. Why not me ?   ;)

Thanks for help.


______________________________________________________________________________, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2002-06-08 04:42:20
Subject: Re: [HACKERS] Schemas: status report, call for developers
Previous:From: Friedrich DodtDate: 2002-06-07 15:55:50
Subject: Where is PLbash ??

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