How do you output comments in a postgres sql script

Question

I'm running a large sql script with postgres as follows:

psql < scriptname.sql

Each sql statement has a comment explaining (using -- syntax) what it does but it isnt output, and its difficult to match up each statement with output. I simply want to output the comments together with the results of the statements

Possibly: Printing to screen in .sql file postgres

Jonathan Lonowski
– Jonathan Lonowski

2014-12-02 17:39:19 +00:00
Commented Dec 2, 2014 at 17:39 — Jonathan Lonowski
– Jonathan Lonowski, Commented Dec 2, 2014 at 17:39

vyegorov · Accepted Answer · 2014-12-02 17:40:10Z

4

Search for the \echo command in the psql reference.

This is psql specific though...

answered Dec 2, 2014 at 17:40

vyegorov

23k7 gold badges61 silver badges76 bronze badges

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

Comments

Michaël Bué · Accepted Answer · 2016-10-05 21:00:06Z

2

Turn echo on with

--echo-all

then use it with \echo type your text

\echo My comment

edited Oct 5, 2016 at 21:00

user330315

answered Oct 5, 2016 at 20:50

Michaël Bué

195 bronze badges

Collectives™ on Stack Overflow

How do you output comments in a postgres sql script

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related