Print line?
Print line?
От:
markus.cl@gmx.de (Markus Dehmann)
Дата:
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;
Re: Print line?
От:
Ian Barwick <barwick@gmx.net>
Дата:
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
Re: Print line?
От:
Jeff Boes <jboes@nexcerpt.com>
Дата:
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