On Wednesday 27 November 2002 10:13, Tilo Schwarz wrote:
> > Tilo Schwarz <[EMAIL PROTECTED]> writes:
> > > - Is it possible to get not only the two tables, but also their
> > > corresponding two columns involved in a RI-Constraint out of the pg_*
> > > tables just with a SQL query?
> >
> > Not eas
> Tilo Schwarz <[EMAIL PROTECTED]> writes:
> > - Is it possible to get not only the two tables, but also their
> > corresponding two columns involved in a RI-Constraint out of the pg_*
> > tables just with a SQL query?
>
> Not easily --- the column info is buried in the pg_trigger.tgargs entries
>
Tilo Schwarz <[EMAIL PROTECTED]> writes:
> - Is it possible to get not only the two tables, but also their corresponding
> two columns involved in a RI-Constraint out of the pg_* tables just with a
> SQL query?
Not easily --- the column info is buried in the pg_trigger.tgargs entries
for the RI t
Dear all,
after reading about the pg_* system tables, I made up a view to see the all
user columns, their type, default value, indices etc. at once (see example
below). Now my first question is:
- Is it possible to get the same result with a simpler / shorter SQL query
than shown below (I'm no
