Chris Travers (Sunday 28 December 2003 01:24) > With 7.4, PostgreSQL implements the standard information_schema so that one > can essentially get all this information in a standard way with will > presumably not be brokent too much in future versions. Prior to this > release, you have to dig the information out of the system catelogs which > would periodically change. > > Here are some examples (see the docs on the information schema ;-)
This rocks! Thank you for the information! > Another hint-- run psql -E to echo the queries to the screen, so that you > can see how the information is being requested from the system catalogs. This is what I've always relied on... > WARNING: Using the system catalogs is NOT supported across versions, as > they tend to change from time to time. Use the information_schema instead > wherever possible :-) And this is the problem I discovered the hard way ;-). Vertu sæll, -- Sigþór Björn Jarðarson (Casey Allen Shobe) http://rivyn.livejournal.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
