Thread: libpq and db information
hello, is there any way to be able to peer to a database' information (tables and their fields) similar to reflection in java using libpq? i know one can use the \d recursively but isn't there a way using libpq? i need the information to properly modify a particular part in radius. thanks. [---] Neil D. Quiogue <neil@iphil.net> IPhil Communications Network, Inc. Other: neil@postgresql.org
On Mon, 12 Jan 1998, neil d. quiogue wrote: > is there any way to be able to peer to a database' information (tables and > their fields) similar to reflection in java using libpq? i know one can > use the \d recursively but isn't there a way using libpq? i need the > information to properly modify a particular part in radius. don't you just love replying to your own questions. i'm looking at how pg_dump.c implemented it (through the system catalogue). unless anyone has another answer, i'll be glad to hear it. [---] Neil D. Quiogue <neil@iphil.net> IPhil Communications Network, Inc. Other: neil@postgresql.org
On Mon, 12 Jan 1998, neil d. quiogue wrote:
> hello,
>
> is there any way to be able to peer to a database' information (tables and
> their fields) similar to reflection in java using libpq? i know one can
> use the \d recursively but isn't there a way using libpq? i need the
> information to properly modify a particular part in radius.
Not sure if this is what you are looking for, but to implement
this in some of my code, I just went into the pg_dump.c code and pulled
out the required SQL statement...
On Mon, 12 Jan 1998, neil d. quiogue wrote: > hello, > > is there any way to be able to peer to a database' information (tables and > their fields) similar to reflection in java using libpq? i know one can > use the \d recursively but isn't there a way using libpq? i need the > information to properly modify a particular part in radius. In jdbc, there are methods that allow you to get details about what tables and columns are present, and their details. I'm still working on the code to get information about access rights to the various tables. All of these use SQL queries, based on libpq. These are new additions to the jdbc driver for V6.3, due beta Feb 1st. -- Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk Main Homepage: http://www.demon.co.uk/finder Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk