Re: How to pipe the psql copy command to Unix 'Date' command

Поиск
Список
Период
Сортировка
От Mirko Pace
Тема Re: How to pipe the psql copy command to Unix 'Date' command
Дата
Msg-id 8eae94e10902190907r497ba9eas7c5b5fbfbe49d3c5@mail.gmail.com
обсуждение исходный текст
Ответ на How to pipe the psql copy command to Unix 'Date' command  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
Список pgsql-general
Дерево обсуждения
Why not call a function that make an insert as "insert into dummy values ('Start',now())" ?

Mirko




On Thu, Feb 19, 2009 at 5:37 PM, SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com> wrote:
Hi,
I want to find the time taken by this process ...retrieving data from oracle database using java and copying that to postgres using copy.
So I need something like this

Start_Time|java testCode ...|psql -c "copy dummy from stdin with delimiter ',' null 'NULL'" test| End_time

so that the output is like this

Start_time 2009-02-19 11:30:15
End_time 2009-02-19 11:40:15

This should give me the time this process started and the time it ended. Is  that possible?


Thanks
Sharmila




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: SHARMILA JOTHIRAJAH
Дата:
Сообщение: How to pipe the psql copy command to Unix 'Date' command
Следующее
От: Kevin Murphy
Дата:
Сообщение: Aliasing syntax question