Re: newbie needs help with postgres internal tables - Mailing list pgsql-general

From William WAISSE
Subject Re: newbie needs help with postgres internal tables
Date
Msg-id 200111231817.fANIH4U48140@smtp4.cluster.oleane.net
Whole thread Raw
In response to Re: newbie needs help with postgres internal tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: newbie needs help with postgres internal tables
List pgsql-general
Le Friday 23 November 2001 12:23, Tom Lane a écrit :

> See the "system catalogs" chapter of the developer's guide.  It's a bit
> terse but I believe the information you mention above is all stated at,
> eg,
> http://candle.pha.pa.us/main/writings/pgsql/sgml/catalog-pg-attribute.html
>
 hum, now I looked at those catalogs, I'm nearly sure there is no id in
pg_database that would allow me to select all the tables ( class ) that
belong to a particular database.

 Whereas it's possible to find all the fields in a table ).

 This seems to me impossible !

 It's necessary cause I want to display in a treeview ( GtkCtree ) all the
the tables in a particular database, and for each table, all the fields in
this table ).

 I will have to maintain myself a table containing a record for each table
created in a database by my ( future ) application.

 can someone tell me this is the only solution ?

--
cordialement,  William WAISSE fpr = 9CCD 7DA2 7050 8805 F471  03D1 DF76 B78C
690B 4E07
  --
Computers are like air conditionners. They work better when you close windows.
  --
Visitez donc mon site perso (version 0.4 du 29/05/2001) :
http://www.neofutur.net
  --
Vous habitez dans l'Essonne et vous aimez les Pingouins ???
visitez donc la GAULE(=LUG91) : http://www.gaule.org
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCS/E/MU d- s: a- C++++ UL+++ P+ L++++ E--- W++ N o-- K- w---
O- M- V- PS+ PE-- Y++ PGP++ t+ 5 X++ R++ tv- b+++ DI- D G e++ h* r++ y+++
------END GEEK CODE BLOCK------

pgsql-general by date:

Previous
From: William WAISSE
Date:
Subject: Re: newbie needs help with postgres internal tables
Next
From: Stephan Szabo
Date:
Subject: Re: Classes (Object Oriented) in PostgreSQL question