Re: Is it possible to have psql ignore the line I am typing?

Hi everybody,

Is it possible to have psql ignore the line I am typing?
That is, similar to '#' with unix shell. What I would
like is to document my interaction with psql. If an
exclamation mark were a comment character, I may type
something like:

silver=# ! I need to find out if data tagged as KIAA
silver=# ! got into silver database last night.
silver=#
silver=# select type, name, marker
silver-# from marker_table
silver-# where tag LIKE 'KIAA%';

It would be nice to be able to jot down what little stream
of thoughts come to my finger tip while I converse with
psql.

Thank you in advance.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

On Wed, 2009-10-21 at 17:39 -0700, Tena Sakai wrote:
> Hi everybody,
>
> Is it possible to have psql ignore the line I am typing?
> That is, similar to '#' with unix shell. What I would
> like is to document my interaction with psql. If an
> exclamation mark were a comment character, I may type
> something like:

I believe -- will do what you like;

> silver=# ! I need to find out if data tagged as KIAA
> silver=# ! got into silver database last night.
> silver=#
> silver=# select type, name, marker
> silver-# from marker_table
> silver-# where tag LIKE 'KIAA%';
>
> It would be nice to be able to jot down what little stream
> of thoughts come to my finger tip while I converse with
> psql.
>
> Thank you in advance.
>
> Regards,
>
> Tena Sakai
> tsakai(at)gallo(dot)ucsf(dot)edu
>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

Thank you Joshua!

> I believe -- will do what you like;

It sure does.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
Sent: Wed 10/21/2009 5:41 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Is it possible to have psql ignore the line I am typing?

On Wed, 2009-10-21 at 17:39 -0700, Tena Sakai wrote:
> Hi everybody,
>
> Is it possible to have psql ignore the line I am typing?
> That is, similar to '#' with unix shell. What I would
> like is to document my interaction with psql. If an
> exclamation mark were a comment character, I may type
> something like:

I believe -- will do what you like;

> silver=# ! I need to find out if data tagged as KIAA
> silver=# ! got into silver database last night.
> silver=#
> silver=# select type, name, marker
> silver-# from marker_table
> silver-# where tag LIKE 'KIAA%';
>
> It would be nice to be able to jot down what little stream
> of thoughts come to my finger tip while I converse with
> psql.
>
> Thank you in advance.
>
> Regards,
>
> Tena Sakai
> tsakai(at)gallo(dot)ucsf(dot)edu
>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

On Wed, Oct 21, 2009 at 6:39 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:

> Hi everybody,
>
> Is it possible to have psql ignore the line I am typing?
> That is, similar to '#' with unix shell.
>

I believe the standard "--" remainder of line SQL comment glyph will work,
as should the C-style "/* ... */" block comment symbols.

rls

--
:wq

Thank you, Rosser.

It is interesting to note that -- and "/* ... */"
have slightly different behavior. Former is much
like # in shell or // in some programming languages,
while the latter shows multi-line propensity.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Rosser Schwarz [mailto:rosser(dot)schwarz(at)gmail(dot)com]
Sent: Wed 10/21/2009 5:43 PM
To: Tena Sakai; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Is it possible to have psql ignore the line I am typing?

On Wed, Oct 21, 2009 at 6:39 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:

> Hi everybody,
>
> Is it possible to have psql ignore the line I am typing?
> That is, similar to '#' with unix shell.
>

I believe the standard "--" remainder of line SQL comment glyph will work,
as should the C-style "/* ... */" block comment symbols.

rls

--
:wq