Re: Processing data from table using awk.
От
David G. Johnston
Тема
Re: Processing data from table using awk.
Дата
Msg-id
CAKFQuwZhQaOzwrRuPgmyDJ2jGAEGjLg=Vj1kJSJcf7RybgQLfw@mail.gmail.com
Ответ на
Re: Processing data from table using awk. (Melvin Davidson)
Список
Дерево обсуждения
Processing data from table using awk. John McKown <john.archie.mckown@gmail.com>
Re: Processing data from table using awk. Reid Thompson <Reid.Thompson@ateb.com>
Re: Processing data from table using awk. "Basques, Bob (CI-StPaul)" <bob.basques@ci.stpaul.mn.us>
Re: Processing data from table using awk. John McKown <john.archie.mckown@gmail.com>
Re: Processing data from table using awk. John McKown <john.archie.mckown@gmail.com>
Re: Processing data from table using awk. "David G. Johnston" <david.g.johnston@gmail.com>
Re: Processing data from table using awk. Melvin Davidson <melvin6925@gmail.com>
Re: Processing data from table using awk. "David G. Johnston" <david.g.johnston@gmail.com>
Your best bet is something like
#!/bin/bash
get_data ()
{
QRY=$(psql $HOST $PORT $USER $DBNAME <<_QUERY_
\o your_output_file
SELECT col1, col2, ...., coln
FROM your_table
WHERE <blah>;
_QUERY_
)
}
awk <blah> your_table
I presume you mean "awk <blah> your_output_file" ...
David J.
В списке pgsql-general по дате отправления
