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 http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
