database structure / generic client apps - Mailing list pgsql-interfaces

From Bob Lapique
Subject database structure / generic client apps
Date
Msg-id 200206071652.110c@th00.opsion.fr
Whole thread Raw
List 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.


Thanks.

______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif




pgsql-interfaces by date:

Previous
From: Dave Cramer
Date:
Subject: Re: [JDBC] I have implemented CallableStatement
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Schemas: status report, call for developers