Обсуждение: Command for getting columns

Поиск
Список
Период
Сортировка

Command for getting columns

От
Jeffrey Napolitano
Дата:
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

Re: [GENERAL] Command for getting columns

От
The Web Administrator
Дата:
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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++