From: Daniel Ariel <pgsqlinterfaces@netzach.co.il>
To: pgsql-interfaces@postgresql.org
Subject: Obtaining information on the schema of tables which I do not own
Date: Mon, 12 Dec 2005 23:02:52 +0200 (IST)
Message-ID: <Pine.LNX.4.58.0512122253330.25426@perpetual.jerusalem.plus.com> (raw)
Dear list,
I am currently developing an application which needs to know information
about table schema in order to display them correctly (specificly
foreign keys, default values and not null characteristics).
For security reasons I would prefer for it not to run as superuser.
I may often wish to display tables which I do not own and potentially
not even have anything other than SELECT permissions to. I will need the
schema information for these tables.
It is desirable since the app needs to also work with other DB's
besides postgres, to implement the requirements using as standard a
technique as possible, and consequently the views inside
information_schema look to me to be the best option. The problem is
that as best as I can tell from experimentation and reading the
documentation, I am only given information on tables owned by the
current user.
Is there any way to achieve I want without being forced to use the
postgres-specific system tables ?
Your assistance is much appreciated,
Daniel
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pgsqlinterfaces@netzach.co.il
Subject: Re: Obtaining information on the schema of tables which I do not own
In-Reply-To: <Pine.LNX.4.58.0512122253330.25426@perpetual.jerusalem.plus.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox