Re: Redirecting output from a SELECT command

At 01:42 PM 11/11/2010, Andreas Kretschmer wrote:
>peter@vfemail.net <peter@vfemail.net> wrote:
>
>>
>> >From a shell prompt in FreeBSD, I can use a command like:
>>
>>     cat file.txt | mail email@domain.com
>>
>> to e-mail the contents of a file somewhere.
>>
>> Is it possible from a PostgreSQL pgsql> shell prompt to e-mail the results of a:
>>
>>     select * from table;
>>
>> command somewhere?
>
>Sure.
>
>psql db_name -c "select * from table" | mail email@domain.com

Super.  Thank you!


-------------------------------------------------
This message sent via VFEmail.net
http://www.vfemail.net
$14.95 Lifetime accounts - 1GB disk, No bandwidth quotas!