Re: Add ANALYZE to tab complete in psql

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026