Redirecting output from a SELECT command

Поиск
Список
Период
Сортировка
Искать
От
peter@vfemail.net
Тема
Redirecting output from a SELECT command
Дата
Msg-id
20101111180537.8E9CD1336971@mail.postgresql.org
Список
Дерево обсуждения
Re: Redirecting output from a SELECT command Jasen Betts <jasen@xnet.co.nz>

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, and I 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 по дате отправления
От: Mladen Gogala
Дата:
Сообщение: Re: CSVLOG fields
От: Richard Broersma
Дата:
Сообщение: Re: CSVLOG fields
FAQ