Skip site navigation (1) Skip section navigation (2)

Better psql tab-completion support for schemas and tables

From: Greg Sabino Mullane <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Better psql tab-completion support for schemas and tables
Date: 2007-10-21 19:33:16
Message-ID: 1192995196.10602.1.camel@greg-laptop (view raw or flat)
Thread:
Lists: pgsql-patches
(oops, this time with -c, thanks Alvaro)

Full support for all schema and table name combinations when 
getting a list of attributes. All of the following will now work:

select * from information_schema.columns where <tab>
select * from foo where <tab>
select * from "user" where <tab>
select * from "foo" where <tab>
select * from "Uppercase".lower where <tab>
select * from "gtsm.com"."foo.Bar" where <tab>
select * from "GTSM.com".foo where <tab>

Also applies to other places that get lists of columns: insert into,
alter table, create index, etc.

--
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200710211532
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8


Attachment: tabcomplete_schema_table.patch
Description: text/x-patch (11.1 KB)

Responses

pgsql-patches by date

Next:From: Tom RaneyDate: 2007-10-21 19:40:04
Subject: Hash Index Build Patch v2
Previous:From: Alvaro HerreraDate: 2007-10-21 17:51:05
Subject: Re: Better psql tab-completion support for schemas andtables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group