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

Re: field names

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: field names
Date: 2005-04-23 04:30:32
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
On Thu, Apr 21, 2005 at 02:37:53PM -0400, Jodi Kanter wrote:
> I'd like to check field names for various tables in our code. Is there a 
> system table that lists the field names of each table? ...some way to 
> query this information to run an error check?

See the "System Catalogs" and "The Information Schema" chapters in
the documentation (the latter in 7.4 and later).

Michael Fuhr

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-04-23 05:06:23
Subject: Re: SQL code versioning (views, functions, etc)
Previous:From: Alvaro HerreraDate: 2005-04-23 04:24:01
Subject: Re: field names

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