Re: inquiry on readline functionality on psql client - Mailing list pgsql-general

From Carlo Florendo
Subject Re: inquiry on readline functionality on psql client
Date
Msg-id 41771B52.6050002@hq.astra.ph
Whole thread Raw
In response to inquiry on readline functionality on psql client  (Carlo Florendo <list-subscriber@hq.astra.ph>)
List pgsql-general
Carlo Florendo wrote:

> Hello,
>
> I appreciate very much the readline functionality on the psql client.
> However, I'd like to ask if it is possible for the readline
> functionality to gobble up even table names and field names:
>
> For example, if have tables
>
> `table1' with 3 fields `field1', 'field2', and `field3'
>
> and
>
> `table2' with 3 fields `field1', 'field2', and `field3',
>
> Is it possible to do
>
> select <tab>    # then, after tabbing I  select `table1'
>
> then
>
> select table1.<tab> #  then, after tabbing I select field2
>
> Thus, I would have the complete statment
>
> `select table1.field2 from table1'
>
> Well, the above statement  is equivalent to
>
> `select field1 from table1'

Sorry, the above sql shoud read `select field2 from table1'

Thank you very much.

Best Regards,

Carlo

--
Carlo Florendo
Astra Philippines Inc.
www.astra.ph


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: generic sql question
Next
From: "Ed L."
Date:
Subject: Re: Invalid page header