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

Re: [QUESTIONS] Names of columns

From: sferac(at)bo(dot)nettuno(dot)it
To: "Ing(dot) Roberto Andrade" <randrade(at)campus(dot)iztacala(dot)unam(dot)mx>
Cc: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: Re: [QUESTIONS] Names of columns
Date: 1998-01-23 17:38:54
Message-ID: Pine.LNX.3.96.980123173539.485A-100000@nero (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
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(at)bo(dot)nettuno(dot)it        /____|__|  |  __|___________              ~
     Fax. ++39 51 6131537 ____________|_____|_/ LUSIADAS /     (Luis de Camoes,
     Tel. ++39 51  591054  \  o                         / Os Lusiadas, canto I)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


pgsql-es-ayuda by date

Next:From: Salvador Fernandez BarquinDate: 1998-01-23 18:01:32
Subject: Re: Anuncio importante
Previous:From: Ing. Roberto AndradeDate: 1998-01-23 16:25:05
Subject: Anuncio importante

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