Thread: psql and \p\g

psql and \p\g

From
Bruce Momjian
Date:
I have found that typing:
test=> select * from pg_class\p\g

no longer works.  I honors the \p, but ignores the \g.

Any ideas Peter?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: psql and \p\g

From
Peter Eisentraut
Date:
On 1999-11-11, Bruce Momjian mentioned:

> I have found that typing:
> 
>     test=> select * from pg_class\p\g
> 
> no longer works.  I honors the \p, but ignores the \g.
> 
> Any ideas Peter?

select * from foo \p \g

This was done to normalize the grammar a little bit (haha, very
funny). In particular it allows this sort of stuff:
=> select * from foo \p \o out.txt \g \\ select * from foo 2 \x \g
etc.

Is it *really* necessary to be able to omit the space?

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



Re: psql and \p\g

From
Bruce Momjian
Date:
> On 1999-11-11, Bruce Momjian mentioned:
> 
> > I have found that typing:
> > 
> >     test=> select * from pg_class\p\g
> > 
> > no longer works.  I honors the \p, but ignores the \g.
> > 
> > Any ideas Peter?
> 
> select * from foo \p \g
> 
> This was done to normalize the grammar a little bit (haha, very
> funny). In particular it allows this sort of stuff:
> => select * from foo \p \o out.txt \g \\ select * from foo 2 \x \g
> etc.
> 
> Is it *really* necessary to be able to omit the space?
> 

Yes, I believe it is, in the sense that many people are used to doing
them together.  Can a backslash trigger some separation of commands, or
at least \p\g be recognized correctly.  I don't think there are other
meaningful combinations.

Can you add a unix-style timestamp for \T?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: [HACKERS] Re: psql and \p\g

From
Tom Lane
Date:
Bruce Momjian <maillist@candle.pha.pa.us> writes:
>> This was done to normalize the grammar a little bit (haha, very
>> funny). In particular it allows this sort of stuff:
>> => select * from foo \p \o out.txt \g \\ select * from foo 2 \x \g
>> etc.
>> 
>> Is it *really* necessary to be able to omit the space?

> Yes, I believe it is, in the sense that many people are used to doing
> them together.  Can a backslash trigger some separation of commands, or
> at least \p\g be recognized correctly.  I don't think there are other
> meaningful combinations.

It'd probably be sufficient if backslash-commands that never take
parameters can be adjacent to a following backslash command.
        regards, tom lane


Re: psql and \p\g

From
Peter Eisentraut
Date:
On Thu, 11 Nov 1999, Bruce Momjian wrote:

> Can you add a unix-style timestamp for \T?

Do you mean \echo `date` ?

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



Re: psql and \p\g

From
Bruce Momjian
Date:
> On Thu, 11 Nov 1999, Bruce Momjian wrote:
> 
> > Can you add a unix-style timestamp for \T?
> 
> Do you mean \echo `date` ?
> 

Oh, very nifty.  Never mind.  I didn't see that.

Seems you have added more powerful flags to take over some of the old
flag usage. If you want to remove some of the older psql flags and
require them to use your newer syntax that allows more functionality,
you can do it.

If you want, just print an error message for the old flag showing them
the new syntax to use and we can remove the messages after a few
releases.

However, some of the more popular flags should probably be left in.
Maybe it should just be left alone.  Not sure.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026