pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedgetting the correct column size....
2+ messages / 2 participants
[nested] [flat]
* getting the correct column size....
@ 2006-08-05 20:43 osxdeveloper@mac.com
2006-08-06 20:26 ` Re: getting the correct column size.... Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: osxdeveloper@mac.com @ 2006-08-05 20:43 UTC (permalink / raw)
To: pgsql-interfaces
Hi all!
I am developing an application (on Mac OS X, using ObjC and Cocoa)
the uses
the libpq client library. Now I have difficulties to get the correct
size of several sql types.
for example:
A table as a char(10) column.
When I get the size via PQfmod() I get 14 as size value.
2. example:
My table has a decimal(19,4) field (19=precision, 4=scale).
How can I get the 19,4 value via the client lib?
I did not find any other way to get column sizes.
How can I get the values?
Thanks for any help!
Regards,
Ralf
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: getting the correct column size....
2006-08-05 20:43 getting the correct column size.... osxdeveloper@mac.com
@ 2006-08-06 20:26 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2006-08-06 20:26 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: osxdeveloper@mac.com
osxdeveloper@mac.com wrote:
> My table has a decimal(19,4) field (19=precision, 4=scale).
> How can I get the 19,4 value via the client lib?
Perhaps you will find the information schema helpful.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-06 20:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-05 20:43 getting the correct column size.... osxdeveloper@mac.com
2006-08-06 20:26 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox