Command for getting columns

Started by Jeffrey Napolitanoalmost 28 years ago2 messagesgeneral
Jump to latest
#1Jeffrey Napolitano
jnapoli@setech.com

I want to get the names of the columns in a table ... I know I can get
it through "\d" in the interactive monitor, but when accessing the
databases non-interactively, how can I get the names of the columns?

------------------
Jeffrey Napolitano
Lowly Intern
Software Emancipation Technology

#2The Web Administrator
wwwadmin@wizard.ca
In reply to: Jeffrey Napolitano (#1)
Re: [GENERAL] Command for getting columns

Look at the man libpq for nfield function, or in perldoc Pg for the same

Jeffrey Napolitano wrote:

I want to get the names of the columns in a table ... I know I can get
it through "\d" in the interactive monitor, but when accessing the
databases non-interactively, how can I get the names of the columns?

------------------
Jeffrey Napolitano
Lowly Intern
Software Emancipation Technology

--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Michael - System Administrator Working in Cheap Canadian
Dollars
Unix Administration - WebSite Hosting - Network Services - Programming
Wizard Internet Services - TechnoWizard Computers - Wizard Tower
TechnoServices
------------------------------------------------------------------------------

(604) 589-0037 Beautiful British Columbia, Canada
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++