Thread: TEXT type blob extraction in ecpg

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 issue for 
PostGres.  Anyone have any suggestions?

Thanks,

Tom

I think don't really unterstand your intend.
However there exists a type text in SQL and Postgres which is a text of
unspecified length and used like a SQL-String. Thus quoted with '

So when you earlier were able to gain the content of that field. It should
be no problem to quote it.

> -----Original Message-----
> From: none none [mailto:mytofi@hotmail.com]
> Sent: Montag, 10. Jänner 2005 18:43
> To: pgsql-sql@postgresql.org
> Subject: [SQL] TEXT type blob extraction in ecpg
>
>
>
> 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 issue for
> PostGres.  Anyone have any suggestions?
>
> Thanks,
>
> Tom
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>