Postgres Pro
Downloads
Home   >   mailing lists

Thread: improve psql lo_* help

improve psql lo_* help

From
Christopher Kings-Lynne
Date:
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)
      {

Re: improve psql lo_* help

From
Bruce Momjian
Date:
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

Re: improve psql lo_* help

From
Bruce Momjian
Date:
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