[wplug] Postgres script comment

[Andreas Rindler]

awesome!!!
thanks

On Thu, 2003-11-13 at 15:39, John Harrold wrote:
> Sometime in November Andreas Rindler assaulted the keyboard and produced:
> 
> | hey,
> | i am populating a lot of data in postgres using sql scripts  and the \i
> | command. how can i include a comment in the sql file that will print to
> | the psql screen during runtime?? 
> | 
> | eg:
> | 
> | In the sql file:
> | 
> | create table test(col1 number, col2 number);
> | --comment: creating table test
> | 
> | Which should show up in the psql prompt as:
> | 
> | CREATE TABLE
> | comment: creating table test
> 
> 
> 
> this should work:
> 
>  \echo creating table test
> 
> from the psql prompt, you know:
> 
> $ psql dbname
> 
> dbname=# \?
> 
>  ...
>  \e [FILE]      edit the query buffer (or file) with external editor
>  \echo [STRING] write string to standard output
>  \encoding [ENCODING]  show or set client encoding
>  ...