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 16:17:34
Message-ID: 1192983454.18255.72.camel@greg-laptop (view raw or flat)
Thread:
Lists: pgsql-patches
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 200710211212
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8


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

Responses

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2007-10-21 17:51:05
Subject: Re: Better psql tab-completion support for schemas andtables
Previous:From: Luke LonerganDate: 2007-10-20 17:19:43
Subject: Re: Including Snapshot Info with Indexes

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