Re: Print line? - Mailing list pgsql-admin

From Jeff Boes
Subject Re: Print line?
Date
Msg-id ap5si2$1idu$1@news.hub.org
Whole thread Raw
In response to Print line?  (markus.cl@gmx.de (Markus Dehmann))
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Point in Time Backups
Next
From:
Date:
Subject: Re: Recover data from crashed HD