Postgresql WITH RECURSIVE COPY TO

Question

In a WITH RECURSIVE query, is it possible to to use COPY TO in the same way INSERT INTO?

I'm trying to write a file from a recursive query without having to save it to a table first.

Please Edit your question and add some sample data and the expected output based on that data. Formatted text please, no screen shots. edit your question - do not post code or additional information in comments. — user330315
– user330315, Commented Oct 20, 2017 at 15:35

Vao Tsun · Accepted Answer · 2017-10-20 15:42:07Z

3

sure why not, eg:

t=# copy ( WITH RECURSIVE t(n) AS (
    VALUES (1)
  UNION ALL
    SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t) to '/tmp/rc';
COPY 1
Time: 5.161 ms
t=# \! cat /tmp/rc
5050

answered Oct 20, 2017 at 15:42

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

IMSoP Over a year ago

I think the OP might be trying to use the COPY inside the CTE. But if not, this is a decent attempt to answer a very vague question.

Vao Tsun Over a year ago

hm... in that case it would take dynamic plpgsql I guess... but then why CTE?.. Well - lets see what OP says :) good point though - I reread the OP - yes it definetely might be the request

Collectives™ on Stack Overflow

Postgresql WITH RECURSIVE COPY TO

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related