Developer Forum

Shachar,

This is a very helpful tidbit that I hadn't realized and it will save me a
significant amount of time figuring out such queries in the coming weeks.
Thank you.

Would it be worthwhile to move many of these \d queries into the system
schema, as views on various system tables? I've thought that it would be
very useful to be able to access these things through the web or other
clients. I could see the benefit of providing users with a consistent
interface
to such "database metadata", no matter what client one is using. (OTOH, one
could argue, learning to do that is a pgsql rite-of-passage. ;-> ).

Shawn Harrison

----- Original Message -----
"Type",


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to XXXX@XXXXX.COM )

"Shawn Harrison" < XXXX@XXXXX.COM > writes:

There's been talk of that in the past, but no one's gotten around to
doing much about it. If you are interested in working on it, look
into the mail list archives for past discussions.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to XXXX@XXXXX.COM )

On Mon, Mar 01, 2004 at 11:09:32 -0600,


If you are using 7.4.x look at the information_schema schema. This is going
to provide a stable way to get meta data.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster