Re: convert 'foobar'::text to the string foobar

On Fri, 13 May 2005, Guillaume Cottenceau wrote:

> I want to retrieve the default value of a TEXT column of a table.

You might want to consider DatabaseMetaData.getColumns() and using the
COLUMN_DEF column.

> ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT 'foobar';
>
> displaying that way with \d:
>
>  column_name   | text                   | not null default 'foobar'::text
>
> retrieved as a String in Java, I end up with "'foobar'::text"
> where I'd need just the string "foobar" (without any quote).
>

That's how it is stored internally and there's not really much we can do
about it.  If you know it's going to be 'xxx'::sometype it would be easy
to parse, but the driver can make no such assumptions.

Kris Jurka