Postgres Pro
Downloads
Home   >   mailing lists

Thread: text metadata

text metadata

From
Tore Halset
Date:
Hello.

This is with PostgreSQL 8.2.3 and jdbc driver 8.2-504.

I have a table with a "text" column. When using DatabaseMetaData to
inspect the column, it is returned as type Types.VARCHAR. I expected
it to be reported as Types.CLOB.

Am I doing something wrong?

Regards,
  - Tore.

Re: text metadata

From
Heikki Linnakangas
Date:
Tore Halset wrote:
> This is with PostgreSQL 8.2.3 and jdbc driver 8.2-504.
>
> I have a table with a "text" column. When using DatabaseMetaData to
> inspect the column, it is returned as type Types.VARCHAR. I expected it
> to be reported as Types.CLOB.
>
> Am I doing something wrong?

No. It's just your expectation that is wrong. :)

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

Re: text metadata

From
Tore Halset
Date:
On Oct 16, 2007, at 10:18 , Heikki Linnakangas wrote:

> Tore Halset wrote:
>> This is with PostgreSQL 8.2.3 and jdbc driver 8.2-504.
>>
>> I have a table with a "text" column. When using DatabaseMetaData to
>> inspect the column, it is returned as type Types.VARCHAR. I
>> expected it
>> to be reported as Types.CLOB.
>>
>> Am I doing something wrong?
>
> No. It's just your expectation that is wrong. :)

Thanks :)

  - Tore.