On Sun, Jan 09, 2005 at 06:45:54AM -0500, Dmitri Bichko wrote:
> CREATE TABLE "foo" (
> "foo_id"serial PRIMARY KEY,
> "type" varchar NOT NULL DEFAULT 'base' CONSTRAINT types CHECK
> (type IN ('base', 'bar'))
> "a" varchar NOT NULL,
> "b" varchar DEFAULT 'some text'
On Mon, Jan 10, 2005 at 01:02:00PM -0500, none none wrote:
> Does any one know how to properly extract a TEXT type blob (undefined char
> length) in ecpg (Linux system)?
If you don't know how much memory to allocate for a column, you
could use a descriptor area and check RETURNED_OCTET_LENGTH.
Does any one know how to properly extract a TEXT type blob (undefined char
length) in ecpg (Linux system)? We are converting our SQL from Informix to
PostGres. Informix had a specific struct defined and I believe handled the
dynamic memory allocation, but I cannot find any guidance on this iss
