Thread: 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@gallo.ucsf.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@gallo.ucsf.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@gallo.ucsf.edu

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Wed 10/21/2009 5:41 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.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@gallo.ucsf.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, 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@gallo.ucsf.edu

-----Original Message-----
From: Rosser Schwarz [mailto:rosser.schwarz@gmail.com]
Sent: Wed 10/21/2009 5:43 PM
To: Tena Sakai; pgsql-admin@postgresql.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@gallo.ucsf.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

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@gallo.ucsf.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