David.Jacques@CCRS.NRCan.gc.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