Thread: Re: Add ANALYZE to tab complete in psql

Re: Add ANALYZE to tab complete in psql

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

> Attached is a trivial patch to add ANALYZE to the tab complete file in
> psql.
>
> ------------------------
> Randy Hall
>
>

> diff -r -u pgsql/src/bin/psql/tab-complete.c pgsql-local/src/bin/psql/tab-complete.c
> --- pgsql/src/bin/psql/tab-complete.c    Wed Jun 20 14:39:14 2001
> +++ pgsql-local/src/bin/psql/tab-complete.c    Mon Jul 30 11:51:40 2001
> @@ -195,7 +195,7 @@
>                 *prev4_wd;
>
>      static char *sql_commands[] = {
> -        "ABORT", "ALTER", "BEGIN", "CLOSE", "CLUSTER", "COMMENT", "COMMIT", "COPY",
> +        "ABORT", "ALTER", "ANALYZE", "BEGIN", "CLOSE", "CLUSTER", "COMMENT", "COMMIT", "COPY",
>          "CREATE", "DECLARE", "DELETE", "DROP", "EXPLAIN", "FETCH", "GRANT",
>          "INSERT", "LISTEN", "LOAD", "LOCK", "MOVE", "NOTIFY", "RESET",
>          "REVOKE", "ROLLBACK", "SELECT", "SET", "SHOW", "TRUNCATE", "UNLISTEN", "UPDATE",

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