resultset metadata libpq

resultset metadata libpq

am 27.07.2010 14:15:03 von Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63508857F6F68INHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi List,

I am using libpq c api to connect postgresql server.

I wanted to retrieve the below metadata information for a column from resul=
tset.

Column name, ( PQfname )
type, (PQftype )
precision, ( ?)
scale, (?)
nullability(?)

Thanks in advance

Regards,
Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63508857F6F68INHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
w.w3.org/TR/REC-html40">




name=3D"place"/>









=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hi List,



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I am using libpq c api to connect
postgresql server.



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I wanted to retrieve the below metadat=
a information
for a column from resultset.



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Column name,  (
nt
size=3D2 color=3Dnavy face=3DArial> ily:Arial;
color:navy'>PQfname )



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> type, (
=3D2
color=3Dnavy face=3DArial> ;
color:navy'>PQftype )



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> precision, ( ?) >



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> scale, (?)
nt>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>nullability(?)
>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Thanks in advance
font>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Regards,



e=3DArial> style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Ravi=
size=3D2 color=3Dnavy face=3DArial> ily:Arial;
color:navy'> Katkar









--_000_46AC8D44F3AE1F4888F137837D0DF63508857F6F68INHYWEXMB2i nf_--

Re: resultset metadata libpq

am 27.07.2010 14:43:58 von Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63508857F6F72INHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



________________________________
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 resul=
tset.

Column name, ( PQfname )
type, (PQftype )
precision, ( ?)
scale, (?)
nullability(?)

Thanks in advance

Regards,
Ravi Katkar

--_000_46AC8D44F3AE1F4888F137837D0DF63508857F6F72INHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
w.w3.org/TR/REC-html40">




namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"place"=
/>









=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 





e=3D3
face=3D"Times New Roman">






ze:10.0pt;
font-family:Tahoma;font-weight:bold'>From:
face=3DTahoma> Ravi Kat=
kar

Sent: Tuesday, July 27, 2010=
5:45
PM

To:
'pgsql-general@postgresql.org'; 'pgsql-odbc@postgresql.org'

Subject: resultset metadata =
libpq





'font-size:
12.0pt'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hi List,



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I am using libpq c api to connect
postgresql server.



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I wanted to retrieve the below metadat=
a
information for a column from resultset.



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Column name,  ( PQfname ) o:p>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> type, (PQftype ) an>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> precision, ( ?) >



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> scale, (?)
nt>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>nullability(?)
>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Thanks in advance
font>



=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Regards,



e=3DArial> style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Ravi=
size=3D2 color=3Dnavy face=3DArial> ily:Arial;
color:navy'> Katkar









--_000_46AC8D44F3AE1F4888F137837D0DF63508857F6F72INHYWEXMB2i nf_--