Hi, I had referred below link I could not able to locate or identify api to retrieve information like precision, scale, nullability.
Thanks, Ravi Katkar -----Original Message----- From: willfurn...@googlemail.com [mailto:willfurn...@googlemail.com] On Behalf Of William Furnass Sent: Tuesday, July 27, 2010 6:21 PM To: Ravi Katkar Cc: pgsql-general@postgresql.org Subject: Re: [ODBC] resultset metadata libpq On 27 July 2010 13:43, Ravi Katkar <ravi.kat...@infor.com> wrote: > > From: Ravi Katkar > Sent: Tuesday, July 27, 2010 5:45 PM > To: 'pgsql-general@postgresql.org'; 'pgsql-o...@postgresql.org' > 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
