The following bug has been logged on the website:
Bug reference: 14645
Logged by: John Norman
Email address: john@7fff.com
PostgreSQL version: 9.4.11
Operating system: OS/X
Description:
Here's a little .sql script in a directory bug/ in my home.
drop database if exists bug;
create database bug;
\c bug
create table bug (id int);
copy bug(id) from program '$HOME/bug/data' csv header;
select * from bug;
It calls a script called data. I run it with psql -X -f
$HOME/bug/setup.sql
This works for the "data" script:
#/bin/bash
echo "id"
echo "1"
echo "2"
This doesn't:
#/bin/bash
echo "id"
echo "1"
psql -X -t -q -c "select 2" | xargs
I can't figure out if psql is disallowed from the program referenced by the
copy program; or if somehow standard out is getting nuked.
The xargs is to remove the spaces are the "2" generated by the psql
command.
My use case was that I wanted part of the script referenced via copy program
to get something out of the database. Didn't work.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs