pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: John Summerfield <postgres@herakles.homelinux.org>
To: pgsql-sql@postgresql.org
Subject: Re: How to query by column names
Date: Tue, 23 Jan 2007 21:01:45 +0900
Message-ID: <45B5F929.8040205@herakles.homelinux.org> (raw)
In-Reply-To: <45B5F7D0.9080801@herakles.homelinux.org>
References: <Pine.LNX.4.64.0701221612220.10491@rray.drdc.mstc.ms.gov>
	<Pine.LNX.4.64.0701221528250.5992@discord.home.frostconsultingllc.com>
	<Pine.LNX.4.64.0701221756520.8787@rray.drdc.mstc.ms.gov>
	<Pine.LNX.4.64.0701221619590.5992@discord.home.frostconsultingllc.com>
	<Pine.LNX.4.64.0701221827420.8787@rray.drdc.mstc.ms.gov>
	<Pine.LNX.4.64.0701221636130.5992@discord.home.frostconsultingllc.com>
	<Pine.LNX.4.64.0701221914400.8787@rray.drdc.mstc.ms.gov>
	<Pine.LNX.4.64.0701221727430.5992@discord.home.frostconsultingllc.com>
	<E1H9Doo-0008U8-CO@fenris.runbox.com>
	<Pine.LNX.4.64.0701222115190.5992@discord.home.frostconsultingllc.com>
	<45B5F7D0.9080801@herakles.homelinux.org>

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

> 



view thread (12+ messages)

Message-ID: <45B5F929.8040205@herakles.homelinux.org>
Permalink:  ../45B5F929.8040205@herakles.homelinux.org/
Also on:    postgresql.org/message-id/45B5F929.8040205@herakles.homelinux.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: postgres@herakles.homelinux.org
  Subject: Re: How to query by column names
  In-Reply-To: <45B5F929.8040205@herakles.homelinux.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox