non superuser creating flat files

Поиск
Список
Период
Сортировка
От Terri Reid
Тема non superuser creating flat files
Дата
Msg-id 003c01c7ddb5$77d33d20$800101df@TERRILAPTOP
обсуждение исходный текст
Ответы Re: non superuser creating flat files
Список pgsql-general

I have data that is being updated in a table that I need to export to a flat file via a database trigger on insert or update. The user performing the update will not be a superuser. I’ve tried to use COPY TO, but that doesn’t work for non-superusers. Is there some other functionality that can write out flat files? I’m looking for something similar to the Oracle UTL file functionality, as ideally I’d want to append the data to an existing file and be able to manipulate the data before I wrote it out.

 

Thanks

Terri

 

Terri Reid

BCT Software Solutions

Mail: treid@edp.co.uk

Tel: 01925 732359

 

 

 

 

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

Предыдущее
От: Jeff Lanzarotta
Дата:
Сообщение: Selecting rows where timestamp between two timestamps
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: copy command - date