функция, которая сохраняет результат запроса в файл. plpgsql
CREATE OR REPLACE FUNCTION my_function() RETURNS VOID AS $$ BEGIN \copy (select * from customers) to '/tmp/out.csv' with csv; END; $$ LANGUAGE plpgsql; SELECT my_function();
Generation
функция, которая сохраняет результат запроса в файл. plpgsql
CREATE OR REPLACE FUNCTION my_function() RETURNS VOID AS $$ BEGIN \copy (select * from customers) to '/tmp/out.csv' with csv; END; $$ LANGUAGE plpgsql; SELECT my_function();
Generate
More than just a code generator. A tool that helps you with a wide range of tasks. All in one place.
Function from Description
Text Description to SQL Command
Translate Languages
Generate HTML from Description
Code to Explanation
Fix invalid Code
Get Test for Code
Class from Description
Regex from Description
Regex to Explanation
Git Command from Description
Linux Command
Function from Docstring
Add typing to code
Get Language from Code
Time complexity
CSS from Description
Meta Tags from Description
− sponsored −