Re: Postgres and GnuPlot

Поиск
Список
Период
Сортировка
От Mila Boldareva
Тема Re: Postgres and GnuPlot
Дата
Msg-id 427F7F86.6050509@pierro.dds.nl
обсуждение исходный текст
Ответ на Postgres and GnuPlot  (Hrishikesh Deshmukh <hdeshmuk@gmail.com>)
Список pgsql-general
>Has anybody tried using gnuplot to plot results from queries; there
>are some suggestions given in PostgreSQL Developer's Handbook but i
>have not any luck so far!
>Any pointers as how to send results from queries straight to a simple
>plotting utility (ex:gnuplot)!
>
>
>
I use a text file as an intermediary.
You only need to slightly modify (postgres output) and/or (gnuplot
input) options:

for postgres, put something like this before the query:

\pset null '?9'
--  or other impossible beginning char to indicate missing values correctly

\t
--  will show only data rows

\f '\t'
-- make sure columns are tab-separated

-- don't align the output:
\a

Instead of the last two, you may change in the gnuplot script:

set datafile separator '|'

Additionally, let gnuplot know your missing columns:
set datafile missing '?'

Hope this helps.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jannelli
Дата:
Сообщение: aide postgres
Следующее
От: "Sean Davis"
Дата:
Сообщение: Re: Postgres and GnuPlot