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
Дата	19 февраля 2009 г. 13:07:56
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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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