Re: How to query by column names - Mailing list pgsql-sql

From John Summerfield
Subject Re: How to query by column names
Date
Msg-id 45B5F929.8040205@herakles.homelinux.org
Whole thread Raw
In response to Re: How to query by column names  (John Summerfield <postgres@herakles.homelinux.org>)
List pgsql-sql
John Summerfield wrote:
> Jeff Frost wrote:
>> On Tue, 23 Jan 2007, Josh Williams wrote:
>>
>>> From: Jeff Frost <jeff@frostconsultingllc.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

> 


pgsql-sql by date:

Previous
From: John Summerfield
Date:
Subject: Re: How to query by column names
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Odbc configuration on Localhost