From: | John Summerfield <postgres(at)herakles(dot)homelinux(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: How to query by column names |
Date: | 2007-01-23 12:01:45 |
Message-ID: | 45B5F929.8040205@herakles.homelinux.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
John Summerfield wrote:
> Jeff Frost wrote:
>> On Tue, 23 Jan 2007, Josh Williams wrote:
>>
>>> From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
>>>> On Mon, 22 Jan 2007, Richard Ray wrote:
>>> ...
>>>
>>> That's definitely part of it. I'm assuming the above is an abridged
>>> example and the OP is doing something dynamic with the query. The
>>> real trouble is Bash likes to expand the asterisk into a list of
>>> every file in the current directory when you try to push the command
>>> through a variable. So it's just a matter of finding a way to escape
>>> the *
>
> Oh, good grief Charlie Brown:
>
> backslash it:
> \*
>
> so:
> echo select \* from whatsit | psql test
Oh
echo select \* from whatsit \; | psql test
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ezequias Rodrigues da Rocha | 2007-01-23 14:35:49 | Odbc configuration on Localhost |
Previous Message | John Summerfield | 2007-01-23 11:56:00 | Re: How to query by column names |