PostgreSQL JDBC question

Thread view:

Martin Gregorie - 27 Apr 2007 20:59 GMT

Quick and obvious question:

Is the Postgres TEXT data type the same as the standard SQL CLOB data type?

This is not, apparently, documented in the java.sql package javadocs,
the Postgres JDBC docs or the Postgres 8.1.8 manual. Leastways, a fairly
careful search in the obvious parts of these documents didn't turn up
anything.

Signature

martin@ | Martin Gregorie
gregorie. | Essex, UK
org |

Reply to this Message

Arne Vajhøj - 28 Apr 2007 02:10 GMT

> Quick and obvious question:
>
> Is the Postgres TEXT data type the same as the standard SQL CLOB data type?

It is the closest match, so I would say yes.

Arne

Reply to this Message

Tarkin - 28 Apr 2007 05:26 GMT

On Apr 27, 3:59 pm, Martin Gregorie <mar...@see.sig.for.address>
wrote:

> Quick and obvious question:
>
[quoted text clipped - 9 lines]
> gregorie. | Essex, UK
> org |

http://db.apache.org/ddlutils/databases/postgresql.html

Concurs w/ Arne.

HTH,
Tarkin
(ps apologies if this posts twice; my interface is hiccuping)

Reply to this Message

Martin Gregorie - 28 Apr 2007 17:19 GMT

> On Apr 27, 3:59 pm, Martin Gregorie <mar...@see.sig.for.address>
> wrote:
[quoted text clipped - 19 lines]
> Tarkin
> (ps apologies if this posts twice; my interface is hiccuping)

Thanks, guys.

Signature

martin@ | Martin Gregorie
gregorie. | Essex, UK
org |

Reply to this Message

PostgreSQL JDBC question

Free Magazines