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: willfurnass@xxxxxxxxxxxxxx [mailto:willfurnass@xxxxxxxxxxxxxx] On Behalf Of William Furnass Sent: Tuesday, July 27, 2010 6:21 PM To: Ravi Katkar Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [ODBC] resultset metadata libpq 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
