Обсуждение: Postgres ODBC driver and BLOBs

Поиск
Список
Период
Сортировка

Postgres ODBC driver and BLOBs

От
Vegeta
Дата:
Hi list,

Is it posible to read and write BLOBs to a PostgreSQL table using
the PostgreSQL ODBC driver?

Thanks in advance,
Guido Urdaneta


Re: [GENERAL] Postgres ODBC driver and BLOBs

От
"Patrick Welche"
Дата:
Vegeta wrote:
>
> Hi list,
>
> Is it posible to read and write BLOBs to a PostgreSQL table using
> the PostgreSQL ODBC driver?
>
> Thanks in advance,
> Guido Urdaneta

I think this is the bit you may need?

     The type used in the driver is simply called "lo" and here is the
     command used to create it:

     create type lo (
         internallength=4,  externallength=10,
         input=int4in, output=int4out,
         default='',  passedbyvalue
     );

quoted from http://www.insightdist.com/psqlodbc/psqlodbc_faq.html under
"Can I use large objects or OLE?"

Cheers,

Patrick