Le mardi 23 août 2011 à 11:29 +0200, Marc Mamin a écrit : > Hello, > > there seems to be no way to use COPY this way, so I guess this is a > feature request... > > this may also help users who tried using COPY FROM STDIN in plpgsql. > > > I have a query with a lot of string manipulation that returns data as > single strings, e.g.: > > > 'a,12,ght,45,1.2' > 'b,13,ght,45,1.1' > 'a,14,ght,45,1.5' > > > in order to save this result into a table, I still need to quote the > string value and use EXECUTE: >
If you can write the data to disk, this gets you rid of the quote problem : COPY query TO 'file.csv'; COPY foo FROM 'file.csv' WITH CSV DELIMITER ','; -- Vincent Veyron http://marica.fr/ Logiciel de gestion des sinistres et des contentieux pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
