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

Re: About table schema

From: Wei Shi <weishisky(at)yahoo(dot)com>
To: Mike Mascari <mascarm(at)mascari(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 03:29:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
This is great.  Thanks.


--- Mike Mascari <mascarm(at)mascari(dot)com> wrote:
> 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
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to

Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger. 

In response to


pgsql-general by date

Next:From: Pavel StehuleDate: 2004-05-26 06:20:43
Subject: planer don't use index. bad plan for where id = x or id in (select ...)
Previous:From: Mike MascariDate: 2004-05-26 02:31:20
Subject: Re: About table schema

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