Re: How to query by column names

From: Richard Ray <rray(at)mstc(dot)state(dot)ms(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to query by column names
Date: 2007-01-23 01:25:22
Message-ID: Pine.LNX.4.64.0701221914400.8787@rray.drdc.mstc.ms.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 22 Jan 2007, Jeff Frost wrote:

> So why are you avoiding "SELECT * FROM t1;" ?
>
I was affeared that if I brought my total ignorance to light I would be
band from the list but here goes.
I work in UNIX/Linux environments.
It's my habit to record my scripts.
A simple example:

#!/bin/bash
CMD="psql -d test \"select * from t1\""
echo $CMD >> my_log
eval $CMD |
while read x; do
do_something_with_x
done

In this example * expands to all files in the current working directory.
I was attempting to get around this by enumerating the table attributes.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Frost 2007-01-23 01:32:28 Re: How to query by column names
Previous Message Jeff Frost 2007-01-23 00:36:49 Re: How to query by column names