| 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 11:56:00 |
| Message-ID: | 45B5F7D0.9080801@herakles.homelinux.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
>> character to keep Bash from globbing, which unfortunately right now is
>> escaping me (no pun intended.)
--
Off-list replies unwelcome
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Summerfield | 2007-01-23 12:01:45 | Re: How to query by column names |
| Previous Message | Achilleas Mantzios | 2007-01-23 08:52:28 | Re: server process (PID xxx) was terminated by signal 7 |