Re: How to query by column names

Поиск
Список
Период
Сортировка
От John Summerfield
Тема Re: How to query by column names
Дата
Msg-id 45B5F7D0.9080801@herakles.homelinux.org
обсуждение исходный текст
Ответ на Re: How to query by column names  (Jeff Frost <jeff@frostconsultingllc.com>)
Ответы Re: How to query by column names
Список pgsql-sql
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


>> character to keep Bash from globbing, which unfortunately right now is 
>> escaping me (no pun intended.)

-- 

Off-list replies unwelcome


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Josh Williams"
Дата:
Сообщение: Re: How to query by column names
Следующее
От: John Summerfield
Дата:
Сообщение: Re: How to query by column names