On 11/11/2016 12:55 AM, Marc Mamin wrote:
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;
In psql(https://www.postgresql.org/docs/9.5/static/app-psql.html):
Long way
\pset fieldsep ','
\pset format unaligned
\pset footer
\o test.csv
SELECT (c.*) t from pg_class c limit 10;
\o
Shorter way:
\copy { table [ ( column_list ) ] | ( query ) } { from | to } {
'filename' | program 'command' | stdin | stdout | pstdin | pstdout } [ [
with ] ( option [, ...] ) ]
Outside psql:
https://www.postgresql.org/docs/9.5/static/sql-copy.html
regards,
Marc Mamin
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
