records to text representation - Mailing list pgsql-general

From Peter Filipov
Subject records to text representation
Date
Msg-id opszpsgh2oligf9v@draco
Whole thread Raw
List pgsql-general
Is there any way to covert an instance of a composite type to text,
to store it in a text column, and then to recreate the original object?
For example:

create type test as (a integer, b text);
create tble tstore (s text);

insert into tstore values((someproc((row(1, 'tst'))::test))::text);
select (someproc(s))::test from tstore;

BTW, I succeeded to create an array of composite types althought I think
i met somewhere in the docs that these are still not supported.
I did it by fiddling with the system catalogs.

pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: Re: SQL injection
Next
From: Richard van den Berg
Date:
Subject: Using native win32 psql.exe using alternative cygwin terminal