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

Re: Table and Field Schemas

From: Richard Huxton <dev(at)archonet(dot)com>
To: Adam Ernst <adam1234(at)athenet(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table and Field Schemas
Date: 2004-11-29 09:46:38
Message-ID: 41AAEFFE.8050508@archonet.com (view raw or flat)
Thread:
Lists: pgsql-general
Adam Ernst wrote:
> How can I get the table schema for a database or the field schema for a 
> table? I'm connected remotely via a socket, so I can't just dump it an 
> inspect the result.
> 
> Even if I could just verify the existence of a table/field, that would 
> work.

If you start psql with the -E flag then \d etc will show the queries 
they send.

You might also want to consider looking at the information_schema schema 
which provides a standardised view of database structure.

-- 
   Richard Huxton
   Archonet Ltd

In response to

pgsql-general by date

Next:From: Richard HuxtonDate: 2004-11-29 09:48:48
Subject: Re: Triggers
Previous:From: Nageshwar RaoDate: 2004-11-29 09:20:20
Subject: tool for postgresql

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