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: Tue, 13 Dec 2005 17:31:13 +0200 (IST)
Message-ID: <Pine.LNX.4.58.0512131730180.2876@perpetual.jerusalem.plus.com> (raw)
Hi all,
We are 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 reasons of security 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.0512131730180.2876@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