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: 20040526032924.37041.qmail@web60302.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
This is great.  Thanks.

Wei

--- 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
majordomo(at)postgresql(dot)org)



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

In response to

Responses

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-2014 The PostgreSQL Global Development Group