postgres psql display format

Question

When I put this in my-script.sql :

RAISE INFO 'Hello, world!';

and run the script with psql, I get :

psql:whole path/my-script.sql:282: INFO:  Hello, world!

How can I replace psql:whole path/my-script.sql:282: with something else (or simply empty) ?

No, this can't be changed. raise was never intended to be used as a "print" alternative. — user330315
– user330315, Commented Apr 20, 2020 at 15:22

jjanes · Accepted Answer · 2020-04-20 15:26:28Z

1

This does not appear to be configurable in such a manner. You would have to make (rather extensive, or very hacky) changes and recompile.

You can get rid of it entirely by doing something like:

cat my-script.sql| psql

answered Apr 20, 2020 at 15:10

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

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

1 Comment

Thanks for replying, I updated the post. So not even set it to empty, like in interactive session ?