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