Re: How to query by column names - Mailing list 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.