Postgres Pro
Downloads
Home   >   mailing lists

Thread: little psql additions

little psql additions

From
Alvaro Herrera
Date:
I append two little patches to psql.  One is for \v.  It is very simple
in that it ignores multibyte stuff, for example.

template1=# \v
Client:
PostgreSQL 7.3devel on i686-pc-linux-gnu, compiled by GCC 2.96
Server:
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96

The second enables tab-complete to analyze.  It ignores schema stuff (so
does every tab-completion command AFAICS)

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Nunca se desea ardientemente lo que solo se desea por razon" (F. Alexandre)
Attachment

Re: little psql additions

From
Bruce Momjian
Date:
I am taking only the tab completion part of this.  Tom Lane added the
version to the psql startup display.

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Alvaro Herrera wrote:
>
> I append two little patches to psql.  One is for \v.  It is very simple
> in that it ignores multibyte stuff, for example.
>
> template1=# \v
> Client:
> PostgreSQL 7.3devel on i686-pc-linux-gnu, compiled by GCC 2.96
> Server:
> PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
>
> The second enables tab-complete to analyze.  It ignores schema stuff (so
> does every tab-completion command AFAICS)
>
> --
> Alvaro Herrera (<alvherre[a]atentus.com>)
> "Nunca se desea ardientemente lo que solo se desea por razon" (F. Alexandre)

Content-Description: Analyze tab completion

[ Attachment, skipping... ]

Content-Description: Version backslash command

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: little psql additions

From
Bruce Momjian
Date:
I have applied the tab completion part of this patch. The version
feature was added to the standard startup banner.

---------------------------------------------------------------------------

Alvaro Herrera wrote:
>
> I append two little patches to psql.  One is for \v.  It is very simple
> in that it ignores multibyte stuff, for example.
>
> template1=# \v
> Client:
> PostgreSQL 7.3devel on i686-pc-linux-gnu, compiled by GCC 2.96
> Server:
> PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
>
> The second enables tab-complete to analyze.  It ignores schema stuff (so
> does every tab-completion command AFAICS)
>
> --
> Alvaro Herrera (<alvherre[a]atentus.com>)
> "Nunca se desea ardientemente lo que solo se desea por razon" (F. Alexandre)

Content-Description: Analyze tab completion

[ Attachment, skipping... ]

Content-Description: Version backslash command

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073