Non-superuser creating a flat file

Поиск
Список
Период
Сортировка
От Terri Reid
Тема Non-superuser creating a flat file
Дата
Msg-id 003001c7ddb3$478f5a10$800101df@TERRILAPTOP
обсуждение исходный текст
Ответы Re: Non-superuser creating a flat file
Список 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 по дате отправления:

Предыдущее
От: Alan J Batsford
Дата:
Сообщение: Problem Designing Index
Следующее
От: "Terri Reid"
Дата:
Сообщение: Re: non superuser creating flat files