Postgresql - pass dynamic file path to COPY in an sql script called from psql

Question

This is very similar to the question here:

Postgresql - pass parameters to COPY in an sql script

But I'm stuck on how to use the format strategy that totally works when copying to a file, but I need to copy from a file, and pass in part of the file path:

--this doesnt work
SELECT format(
      $$copy mytable(mycolums) from %L || 'my/file/path.csv'$$,
      :v1
   ) \gexec

Laurenz Albe · Accepted Answer · 2021-07-15 14:44:31Z

1

Put the concatenation into the argument to format:

SELECT format(
      $$copy mytable(mycolums) from %L$$,
      :v1 || 'my/file/path.csv'
   ) \gexec

answered Jul 15, 2021 at 14:44

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

Postgresql - pass dynamic file path to COPY in an sql script called from psql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related