From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Daniel Ariel <pgsqlinterfaces@netzach.co.il>
Cc: pgsql-interfaces@postgresql.org, Peter Eisentraut <peter_e@gmx.net>
Subject: Re: Obtaining information on the schema of tables which I do not own
Date: Wed, 14 Dec 2005 13:08:06 -0500
Message-ID: <22357.1134583686@sss.pgh.pa.us> (raw)
In-Reply-To: <20051214173955.GA9238@wolff.to>
References: <Pine.LNX.4.58.0512122253330.25426@perpetual.jerusalem.plus.com>
<20051214173955.GA9238@wolff.to>
Bruno Wolff III <bruno@wolff.to> writes:
> Daniel Ariel <pgsqlinterfaces@netzach.co.il> wrote:
>> 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).
> Probably you should start by seeing if the information schema provides what
> you need:
> http://developer.postgresql.org/docs/postgres/information-schema.html
I think what he was complaining about was that information_schema
restricts access to many things unless you are the table owner.
This is per SQL99, but SQL2003 seems to have relaxed the rules to
allow you to see info about tables you can access (ie, have nonzero
rights for). Updating the information_schema to follow the SQL2003
rules is on the to-do list, but I dunno if anyone is actively working
on it. (Peter?)
regards, tom lane
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: tgl@sss.pgh.pa.us, bruno@wolff.to, pgsqlinterfaces@netzach.co.il, peter_e@gmx.net
Subject: Re: Obtaining information on the schema of tables which I do not own
In-Reply-To: <22357.1134583686@sss.pgh.pa.us>
* 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