Re: Print line?

From: Ian Barwick <barwick(at)gmx(dot)net>
To: markus(dot)cl(at)gmx(dot)de (Markus Dehmann), pgsql-admin(at)postgresql(dot)org
Subject: Re: Print line?
Date: 2002-10-23 13:38:36
Message-ID: 200210231538.36962.barwick@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tuesday 22 October 2002 19:46, Markus Dehmann wrote:
> Hi,
>
> is there an SQL command that just prints a line? I want to do sth like:
>
> -- SQL query
> print "Now displaying cities...";
> SELECT * from cities;

By definition SQL doesn't have any output formatting
functions; those are provided by individual client
applications.

In psql you can use \echo to print a line to standard
output. \? shows other available options.

Ian Barwick
barwick(at)gmx(dot)net

In response to

  • Print line? at 2002-10-22 17:46:37 from Markus Dehmann

Browse pgsql-admin by date

  From Date Subject
Next Message juerg.rietmann 2002-10-23 13:40:01 pg_dump from within a sql statement
Previous Message Stephan Szabo 2002-10-23 13:11:42 Re: newbie psql - Backup/Restore - database