Redirecting output from a SELECT command - Mailing list pgsql-novice

From peter@vfemail.net
Subject Redirecting output from a SELECT command
Date
Msg-id 20101111180537.8E9CD1336971@mail.postgresql.org
Whole thread Raw
Responses Re: Redirecting output from a SELECT command
List pgsql-novice
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?

I'd like to share a printed copy of that output with someone, and there's no printer connected to the database server,
andI only have access to the database server from the console.   


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


pgsql-novice by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: CSVLOG fields
Next
From: Richard Broersma
Date:
Subject: Re: CSVLOG fields