Thread: Print line?

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;

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@gmx.net

On Tue, 22 Oct 2002 13:46:37 -0400, 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;

Try \qecho:


\qecho Now displaying cities
SELECT * FROM cities;

Otherwise you could also do:

\t
SELECT 'Now displaying cities...';
\t
SELECT * FROM cities;


--
Jeff Boes                                      vox 616.226.9550 ext 24
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise