Thread: resultset metadata libpq
Hi List,
I am using libpq c api to connect postgresql server.
I wanted to retrieve the below metadata information for a column from resultset.
Column name, ( PQfname )
type, (PQftype )
precision, ( ?)
scale, (?)
nullability(?)
Thanks in advance
Regards,
Ravi Katkar
From: Ravi Katkar
Sent: Tuesday, July 27, 2010 5:45 PM
To: 'pgsql-general@postgresql.org'; 'pgsql-odbc@postgresql.org'
Subject: resultset metadata libpq
Hi List,
I am using libpq c api to connect postgresql server.
I wanted to retrieve the below metadata information for a column from resultset.
Column name, ( PQfname )
type, (PQftype )
precision, ( ?)
scale, (?)
nullability(?)
Thanks in advance
Regards,
Ravi Katkar
On 27 July 2010 13:43, Ravi Katkar <Ravi.Katkar@infor.com> wrote: > > From: Ravi Katkar > Sent: Tuesday, July 27, 2010 5:45 PM > To: 'pgsql-general@postgresql.org'; 'pgsql-odbc@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
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@googlemail.com [mailto:willfurnass@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.Katkar@infor.com> wrote: > > From: Ravi Katkar > Sent: Tuesday, July 27, 2010 5:45 PM > To: 'pgsql-general@postgresql.org'; 'pgsql-odbc@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