Re: How to query by column names

On Mon, 22 Jan 2007, Richard Ray wrote:

> 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.

Oh! Why didn't you just say that in the first place. You just need quotes.
Try this:

psql -c 'select * from t1' test

or

psql -c "select * from t1" test

or

echo "select * from t1" | psql test

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954