On 27 July 2010 13:43, Ravi Katkar <Ravi.Katkar@xxxxxxxxx> wrote: > > From: Ravi Katkar > Sent: Tuesday, July 27, 2010 5:45 PM > To: 'pgsql-general@xxxxxxxxxxxxxx'; 'pgsql-odbc@xxxxxxxxxxxxxx' > Subject: resultset metadata libpq > > I wanted to retrieve the below metadata information for a column from > resultset. > > Column name, ( PQfname ) > > type, (PQftype ) > > precision, ( ?) > > scale, (?) > > nullability(?) Take a look at http://www.enterprisedb.com/documentation/libpq-concepts.html. You can find the number of columns of a PGresult then iterate over the columns to get column names, data types etc. Will -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
