Re: Print line?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Print line?
Date: 2002-10-23 18:08:30
Message-ID: ap5si2$1idu$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

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 mallah 2002-10-23 18:23:39 Re: Recover data from crashed HD
Previous Message Andrew Sullivan 2002-10-23 18:02:06 Re: Point in Time Backups