row => text => row

[Marc Mamin <M.Mamin@xxxxxxxxxxxx>]

Hello,

 

It is possible to cast a row to text, but is there a way to revert that?

 

e.g.:

 

create temp table test like pg_class;

 

WHITH dummy as (SELECT (c.*)::text t from pg_class c limit 10)

INSERT INTO test

SELECT ???

FROM dummy;

 

 

an other option that would sometimes help me would be to cast rows as text,but in their (default) csv representation:

 

select to_csv((c.*)) from foo c;

 

regards,

 

Marc Mamin