pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql comment char??
8+ messages / 7 participants
[nested] [flat]
* psql comment char??
@ 2000-06-29 23:42 Mark Dzmura <mdz@phalanx.net>
0 siblings, 3 replies; 8+ messages in thread
From: Mark Dzmura @ 2000-06-29 23:42 UTC (permalink / raw)
To: pgsql-interfaces
Sorry for this Q, but I only subscribe to interfaces list...
Is there a comment char/symbol for psql to allow me to annotate files that
I suck in with \i ???? I haven't stumbled on one so for, nor can i find
reference to one in the documentation...
thanks,
Mark Dzmura
--
)))) This email routed via a wireless gateway!! ((((
Attachments:
mdz.vcf (text/x-vcard, 279B) download
begin:vcard
n:Dzmura;Mark
tel;fax:412-429-3361
tel;work:412-429-6001
x-mozilla-html:FALSE
org:Digital Mission, LLC
adr:;;230 E. Main St., Suite 210;Carnegie;PA;15106;USA
version:2.1
email;internet:mdz@digital-mission.com
title:President
x-mozilla-cpt:;0
fn:Mark Dzmura
end:vcard
* Re: psql comment char??
@ 2000-07-03 09:27 Grant Finnemore <gaf@ucs.co.za>
parent: Mark Dzmura <mdz@phalanx.net>
2 siblings, 0 replies; 8+ messages in thread
From: Grant Finnemore @ 2000-07-03 09:27 UTC (permalink / raw)
To: Mark Dzmura <mdz@phalanx.net>; +Cc: pgsql-interfaces
Mark Dzmura wrote:
> Sorry for this Q, but I only subscribe to interfaces list...
>
> Is there a comment char/symbol for psql to allow me to annotate files that
> I suck in with \i ???? I haven't stumbled on one so for, nor can i find
> reference to one in the documentation...
Either -- at start of comment portion (continues to EOL) or /* */ for comment
block -ala C.
>
>
> thanks,
> Mark Dzmura
Grant
--
> Poorly planned software requires a genius to write it
> and a hero to use it.
Grant Finnemore BSc(Eng) (mailto:gaf@ucs.co.za)
Software Engineer Universal Computer Services
Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein
Fax (+27)(11)339-3421 Johannesburg, South Africa
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: psql comment char??
@ 2000-07-03 12:41 eisentrp@csis.gvsu.edu
parent: Mark Dzmura <mdz@phalanx.net>
2 siblings, 0 replies; 8+ messages in thread
From: eisentrp@csis.gvsu.edu @ 2000-07-03 12:41 UTC (permalink / raw)
To: Mark Dzmura <mdz@phalanx.net>; +Cc: pgsql-interfaces
On Thu, 29 Jun 2000, Mark Dzmura wrote:
> Is there a comment char/symbol for psql to allow me to annotate files that
> I suck in with \i ???? I haven't stumbled on one so for, nor can i find
> reference to one in the documentation...
The normal SQL comment characters:
-- (until end of line)
/* ... */
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: psql comment char??
@ 2000-07-03 17:04 Ken J. Wright <ken@ori-ind.com>
parent: Mark Dzmura <mdz@phalanx.net>
2 siblings, 1 reply; 8+ messages in thread
From: Ken J. Wright @ 2000-07-03 17:04 UTC (permalink / raw)
To: Mark Dzmura <mdz@phalanx.net>; pgsql-interfaces
/* this is a comment */
/* this is
also
a
comment
*/
There is also an alternate form, but I can't remember it.
Cheers!
Ken
On Thu, 29 Jun 2000, Mark Dzmura wrote:
> >%_Sorry for this Q, but I only subscribe to interfaces list...
>
> Is there a comment char/symbol for psql to allow me to annotate files that
> I suck in with \i ???? I haven't stumbled on one so for, nor can i find
> reference to one in the documentation...
>
> thanks,
> Mark Dzmura
>
> --
> )))) This email routed via a wireless gateway!! ((((
>
>
>
----------------------------------------
Content-Type: text/x-vcard; name="mdz.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Mark Dzmura
----------------------------------------
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: psql comment char??
@ 2000-07-03 18:43 D'Arcy J.M. Cain <darcy@druid.net>
parent: Ken J. Wright <ken@ori-ind.com>
0 siblings, 1 reply; 8+ messages in thread
From: darcy@druid.net @ 2000-07-03 18:43 UTC (permalink / raw)
To: Ken J. Wright <ken@ori-ind.com>; +Cc: Mark Dzmura <mdz@phalanx.net>; pgsql-interfaces
Thus spake Ken J. Wright
> /* this is a comment */
> /* this is
> also
> a
> comment
> */
>
> There is also an alternate form, but I can't remember it.
I would call those the alternate forms. The canonical (SQL) way is
-- This is a comment
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: psql comment char??
@ 2000-07-03 19:04 Ken J. Wright <ken@ori-ind.com>
parent: D'Arcy J.M. Cain <darcy@druid.net>
0 siblings, 1 reply; 8+ messages in thread
From: Ken J. Wright @ 2000-07-03 19:04 UTC (permalink / raw)
To: pgsql-interfaces
> I would call those the alternate forms. The canonical (SQL) way is
>
> -- This is a comment
Is this part of the SQL-92 spec?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: psql comment char??
@ 2000-07-03 19:30 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Ken J. Wright <ken@ori-ind.com>
0 siblings, 1 reply; 8+ messages in thread
From: Thomas Lockhart @ 2000-07-03 19:30 UTC (permalink / raw)
To: Ken J. Wright <ken@ori-ind.com>; +Cc: pgsql-interfaces
> > I would call those the alternate forms. The canonical (SQL) way is
> > -- This is a comment
> Is this part of the SQL-92 spec?
This is the *only* comment delimiter defined in the SQL92 spec. The "/*
.. */" form is present in several database products since a
block-delimited comment is very useful.
- Thomas
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: psql comment char??
@ 2000-07-03 19:41 Tom Lane <tgl@sss.pgh.pa.us>
parent: Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Tom Lane @ 2000-07-03 19:41 UTC (permalink / raw)
To: Thomas Lockhart <lockhart@alumni.caltech.edu>; +Cc: Ken J. Wright <ken@ori-ind.com>; pgsql-interfaces
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>>>> I would call those the alternate forms. The canonical (SQL) way is
>>>> -- This is a comment
>> Is this part of the SQL-92 spec?
> This is the *only* comment delimiter defined in the SQL92 spec. The "/*
> .. */" form is present in several database products since a
> block-delimited comment is very useful.
Note that SQL99 added /* ... */ comments.
We are not fully compliant with SQL99's comment specifications, since it
specifies that /* ... */ nest, which is a tad hard to implement in a
finite-state lexer :-(
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2000-07-03 19:41 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-29 23:42 psql comment char?? Mark Dzmura <mdz@phalanx.net>
2000-07-03 09:27 ` Grant Finnemore <gaf@ucs.co.za>
2000-07-03 12:41 ` eisentrp@csis.gvsu.edu
2000-07-03 17:04 ` Ken J. Wright <ken@ori-ind.com>
2000-07-03 18:43 ` D'Arcy J.M. Cain <darcy@druid.net>
2000-07-03 19:04 ` Ken J. Wright <ken@ori-ind.com>
2000-07-03 19:30 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2000-07-03 19:41 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox