Thanks Adrian
On 23.01.21 21:45, Adrian Klaver wrote:
On 1/23/21 12:36 PM, robert rottermann wrote:
Hi there
I made somehow a mess with my PostgreSQL installation an an ubuntu 18.4 with
PostgreSQL 10.0
service postgresql status
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/li
Hi Friends
I would like to generate the path of a CSV file to which I output a query.
This is what I try:
CREATEORREPLACEPROCEDUREexport_cvs(
home_dir varchar
)
AS
$BODY$
DECLARE
OUTFILE varchar;
BEGIN
OUTFILE = (home_dir || '/tmp/company.csv');
copy(
select'company_'||id as"External ID",
namea
