Re: Database metadata queries (WAS Re: Moving from MySQL to PGSQL....some questions) - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Database metadata queries (WAS Re: Moving from MySQL to PGSQL....some questions)
Date
Msg-id 20040302170247.GA27448@wolff.to
Whole thread Raw
In response to Database metadata queries (WAS Re: Moving from MySQL to PGSQL....some questions)  ("Shawn Harrison" <harrison@tbc.net>)
List pgsql-general
On Mon, Mar 01, 2004 at 11:09:32 -0600,
  Shawn Harrison <harrison@tbc.net> wrote:
>
> Would it be worthwhile to move many of these \d queries into the system
> schema, as views on various system tables? I've thought that it would be
> very useful to be able to access these things through the web or other
> clients.  I could see the benefit of providing users with a consistent
> interface
> to such "database metadata", no matter what client one is using. (OTOH, one
> could argue, learning to do that is a pgsql rite-of-passage. ;-> ).

If you are using 7.4.x look at the information_schema schema. This is going
to provide a stable way to get meta data.

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: How to Cancel a query ?
Next
From: "Bas Scheffers"
Date:
Subject: Re: Max/min of 2 values function, plpgsql efficency?