[QUESTIONS] Names of columns

[sferac@bo.nettuno.it]

On Thu, 22 Jan 1998, Ing. Roberto Andrade wrote:

> Hi:
> 
> How do I can get the names of the columns retrieved by a sql statement?
> I need the names to put them on the first row of the grid I'm using to 
> display the data.
> 
> TIA,
> 
> Roberto
> 

Se quieres solo los nombres de los campos, prueba asi:

postgres=> select * from comuni where 0=1;

istat|comune|prov|cf|cap|reg
-----+------+----+--+---+---
(0 rows)

                                                            Ciao, Jose'
                                   ___,   /          
                                  |_+_|  /|   /    ~ 
~~~~~~~~~~~~~~~~~~~~~~~~~             | / |  /|           ~~~~~~~~~~~~~~~~~~~~~
    Jose' Soares Da Silva    ~        |/  | / |    /      "As armas e os Baroes
   Progetto "OS LUSIADAS"      ~      |   |/| |   /|        assinalados, que da
     SFERA CARTA SOFTWARE    ~       /|   / | |  / |  Occidental praia Lusitana
        Via Bazzanese, 69           / |  /  | | /| |   por mares nunca de antes
Casalecchio R. BO - Italy          /  | /   | |/ | |       navegados, passarono
http://www.sferacarta.com         /   |/____|_/__|_|   ainda alem da Taprobana"
     sferac@bo.nettuno.it        /____|__|  |  __|___________              ~
     Fax. ++39 51 6131537 ____________|_____|_/ LUSIADAS /     (Luis de Camoes,
     Tel. ++39 51  591054  \  o                         / Os Lusiadas, canto I)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~