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
