Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group