Re: About table schema

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Wei Shi <weishisky(at)yahoo(dot)com>
Cc: Janning Vygen <vygen(at)gmx(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: About table schema
Date: 2004-05-26 02:31:20
Message-ID: 40B40178.8060107@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Wei Shi wrote:
> Is there a function interface to get this information
> other than from "psql" comman line interface?

If you start psql with the '-E' switch, you'll see the queries it
generates to display the meta-data associated with the '\' command
you issue.

You may also query the tables and views in the information_schema
for what you want.

Mike Mascari

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wei Shi 2004-05-26 03:29:24 Re: About table schema
Previous Message Wei Shi 2004-05-26 01:46:03 Re: About table schema