improve psql lo_* help

Started by Christopher Kings-Lynneover 22 years ago3 messagespatches
Jump to latest
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

This makes help like this:

\lo_export LOBOID FILE
\lo_import FILE [COMMENT]
\lo_list
\lo_unlink LOBOID large object operations

Instead of not saying anything about what arguments are required.

Chris

Attachments:

psqlhelp.txttext/plain; name=psqlhelp.txtDownload+6-6
#2Bruce Momjian
bruce@momjian.us
In reply to: Christopher Kings-Lynne (#1)
Re: improve psql lo_* help

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

http://momjian.postgresql.org/cgi-bin/pgpatches

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

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

Christopher Kings-Lynne wrote:

This makes help like this:

\lo_export LOBOID FILE
\lo_import FILE [COMMENT]
\lo_list
\lo_unlink LOBOID large object operations

Instead of not saying anything about what arguments are required.

Chris

Index: src/bin/psql/help.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/bin/psql/help.c,v
retrieving revision 1.81
diff -c -r1.81 help.c
*** src/bin/psql/help.c	2 Oct 2003 06:39:31 -0000	1.81
--- src/bin/psql/help.c	17 Nov 2003 09:02:23 -0000
***************
*** 245,254 ****

fprintf(output, _("Copy, Large Object\n"));
fprintf(output, _(" \\copy ... perform SQL COPY with data stream to the client host\n"));
! fprintf(output, _(" \\lo_export\n"
! " \\lo_import\n"
" \\lo_list\n"
! " \\lo_unlink large object operations\n"));

if (output != stdout)
{
--- 245,254 ----

fprintf(output, _("Copy, Large Object\n"));
fprintf(output, _(" \\copy ... perform SQL COPY with data stream to the client host\n"));
! fprintf(output, _(" \\lo_export LOBOID FILE\n"
! " \\lo_import FILE [COMMENT] \n"
" \\lo_list\n"
! " \\lo_unlink LOBOID large object operations\n"));

if (output != stdout)
{

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/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
#3Bruce Momjian
bruce@momjian.us
In reply to: Christopher Kings-Lynne (#1)
Re: improve psql lo_* help

Patch applied. Thanks.

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

Christopher Kings-Lynne wrote:

This makes help like this:

\lo_export LOBOID FILE
\lo_import FILE [COMMENT]
\lo_list
\lo_unlink LOBOID large object operations

Instead of not saying anything about what arguments are required.

Chris

Index: src/bin/psql/help.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/bin/psql/help.c,v
retrieving revision 1.81
diff -c -r1.81 help.c
*** src/bin/psql/help.c	2 Oct 2003 06:39:31 -0000	1.81
--- src/bin/psql/help.c	17 Nov 2003 09:02:23 -0000
***************
*** 245,254 ****

fprintf(output, _("Copy, Large Object\n"));
fprintf(output, _(" \\copy ... perform SQL COPY with data stream to the client host\n"));
! fprintf(output, _(" \\lo_export\n"
! " \\lo_import\n"
" \\lo_list\n"
! " \\lo_unlink large object operations\n"));

if (output != stdout)
{
--- 245,254 ----

fprintf(output, _("Copy, Large Object\n"));
fprintf(output, _(" \\copy ... perform SQL COPY with data stream to the client host\n"));
! fprintf(output, _(" \\lo_export LOBOID FILE\n"
! " \\lo_import FILE [COMMENT] \n"
" \\lo_list\n"
! " \\lo_unlink LOBOID large object operations\n"));

if (output != stdout)
{

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/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