Re: [QUESTIONS] libpq and db information

From: Peter T Mount <postgresdev(at)maidast(dot)demon(dot)co(dot)uk>
To: "neil d(dot) quiogue" <neil(at)iphil(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-questions(at)postgresql(dot)org
Subject: Re: [QUESTIONS] libpq and db information
Date: 1998-01-12 19:39:48
Message-ID: Pine.LNX.3.95.980112193632.24058A-100000@maidast
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Brian E. Gallew 1998-01-12 19:57:57 RE: [HACKERS] ODBC & LGPL license...
Previous Message Kevin Witten 1998-01-12 18:33:10 (no subject)