how to Insert date (yyyymmdd) into parametized copy statement? (postgreSQL)

Question

Hello i have the following parameterized copy statement:

Do $$
Begin 
EXECUTE format(
           'COPY test FROM PROGRAM ''curl "https://example.com/events/123&start_date=%sT000000Z"''',
           '20210331'
        );
End
$$ ;

and i want to know how could i make the parameterized date at the end (20210331) correspond to a day before the current date, for example as of now it would be '20211905'.

Laurenz Albe · Accepted Answer · 2021-05-20 19:57:53Z

1

You can get that string with

to_char(current_date - 1, 'YYYYDDMM')

answered May 20, 2021 at 19:57

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

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

Collectives™ on Stack Overflow

how to Insert date (yyyymmdd) into parametized copy statement? (postgreSQL)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related