dynamically generate path to output file

Поиск

Список

Период

Сортировка

От	robert@redo2oo.ch
Тема	dynamically generate path to output file
Дата	26 марта 2022 г. 09:35:23
Msg-id	bd57256b-162c-ac18-ecc0-968ee582b744@redo2oo.ch обсуждение
Ответы	Re: dynamically generate path to output file
Список	pgsql-general

Дерево обсуждения

Hi Friends

I would like to generate the path of a CSV file to which I output a query.

This is what I try:

CREATE OR REPLACE PROCEDURE export_cvs(
 home_dir varchar
)
AS
$BODY$
DECLARE
 OUTFILE varchar;
BEGIN
OUTFILE = (home_dir || '/tmp/company.csv');
copy (
 select 'company_'||id as "External ID",
 name as "Name",'True' as "Is a Company",
 email,
 phone ,
 company_registry
 from res_company
 ) TO OUTFILE with CSV HEADER;
END;
$BODY$
 LANGUAGE plpgsql;

this produces a syntax error:

psql:export_contacts_short.sql:21: ERROR: syntax error at or near "OUTFILE"
LINE 17: ) TO OUTFILE with CSV HEADER;

It works fine when I replace "TO OUTFILE" with a hard coded string.

Can anybody of you give me a hint how to do that?

Thanks a lot.

Robert

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

dynamically generate path to output file