CREATE or REPLACE FUNCTION function(account_id integer)RETURNS void AS $$beginexecute 'COPY(SELECT * FROM backup_table WHERE account_id = ' || account_id || 'AND status = 1)TO ''/var/lib/pgsql/'||account_id||'.sql''';end$$ language 'plpgsql';
CREATE or REPLACE FUNCTION function(account_id integer)
RETURNS void AS $$
begin
execute 'COPY
(
SELECT * FROM backup_table WHERE account_id = ' || account_id || 'AND status = 1
)
TO ''/var/lib/pgsql/'||account_id||'.sql''';
end
$$ language 'plpgsql';
select function(63742);
select function (40);
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных