Skip site navigation (1) Skip section navigation (2)

Re: Function for determining column witdhs in libpq ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David(dot)Jacques(at)CCRS(dot)NRCan(dot)gc(dot)ca
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Function for determining column witdhs in libpq ?
Date: 2005-03-04 15:30:10
Message-ID: 27547.1109950210@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
David(dot)Jacques(at)CCRS(dot)NRCan(dot)gc(dot)ca writes:
> I need to build a create table statement based on the some of the field 
>  names I retreive from an existing table. I have made use of the
> functionality
>  in Pqftype() but that doesn't help me distiguish between a column of
>  VARCHAR(20) and a a column of VARCHAR(8). Is there a function in lipq to do
> this ?

PQfmod returns the typmod of the column, which encodes this information.

			regards, tom lane

In response to

pgsql-interfaces by date

Next:From: b tDate: 2005-03-04 18:12:35
Subject: Fwd: Re: how to parse an proargtypes array?
Previous:From: Tom LaneDate: 2005-03-04 15:16:46
Subject: Re: how to parse an proargtypes array?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group