Thread: Is CLOB support?
I have scaned over the postgresq.org and can't confirm whether the CLOB data type is supported in 7.2 or 7.3. I can't see any on-line document say the data type is supported meanwhile I see java code such as http://developer.postgresql.org/docs/pgsql/src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Clob.java in the JDBC implements the data type. Can someone give me a confirmation. -- Regards, Vernon
Vernon wrote: > > I have scaned over the postgresq.org and can't confirm whether the CLOB > data type is supported in 7.2 or 7.3. I can't see any on-line document > say the data type is supported meanwhile I see java code such as > http://developer.postgresql.org/docs/pgsql/src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Clob.java > in the JDBC implements the data type. > When I follow the link above I see methods that throw a NotImplemented exception. PostgreSQL does not have the SQL'99 CLOB type, and I guess this JDBC methods will be used for that as soon as we get the type in the backend. But it does have support for Large Objects in its own particular way (it was implemented before the standard came out) and there is a JDBC extension to deal with this. Look at: http://developer.postgresql.org/docs/pgsql/src/interfaces/jdbc/README at the "Large Object API" section. -- Fernando Nasser Red Hat Canada Ltd. E-Mail: fnasser@redhat.com 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9