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: 200206071652.110c@th00.opsion.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

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

Browse pgsql-interfaces by date

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