Postgres: Pipeline to psql

Question

I have a simple question, but I can't find an answer )

I have following script:

sqsh -S SyBaseServer -U sybuser -P mypass -C 'select top 10000 * from dba.sybtable; -mbcp' | \
awk '{print substr($0, 0, length($0)-1)}' | \
psql -1 postgresql://admin:adminpass@pgserv:5432/pgbase -f sybtopg.sql

How can I add EOF after last string of ouput of awk? I must close STDIN for psql.

Thanks!

PS The reason of fail isn't lack of EOF. It's right pipeline:

sqsh -S SyBaseServer -U sybuser -P mypass -C 'select top 10000 * from dba.wybtable; -mbcp' \
| awk '{print substr($0, 0, length($0)-1)}' | \
/psql  postgresql://admin:adminpass@pgserv:5432/pgbase -c "DELETE FROM testtable; COPY testtable FROM STDIN DELIMITER '|' CSV"

@t0mm13b How is this related? There's no here-doc in this question. — Barmar
– Barmar, Commented Nov 5, 2015 at 22:56
IIUC the reader of a pipe should receive EOF when the (last) writing descriptor is closed, i.e. here when awk ends. Does awk linger for some reason (e.g. because sqsh does not finish and awk's input is still open)? Check with ps from another terminal. — Peter - Reinstate Monica
– Peter - Reinstate Monica, Commented Nov 5, 2015 at 23:00

Barmar · Accepted Answer · 2015-11-05 23:01:42Z

1

You don't need to do anything special. When awk reaches EOF on its input, it will execute its END block (if there is one) and then exit, and this will close the pipe. That will then cause the next process in the pipeline to read EOF.

If you want the awk script to send EOF earlier than that, it will have to exit, by using the exit statement.

answered Nov 5, 2015 at 23:01

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dimaf Over a year ago

Yes, You're right. The reason of fail isn't lack of EOF. Thanks!

Collectives™ on Stack Overflow

Postgres: Pipeline to psql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related