Permissions on copy

Zeugswetter Andreas IZ5 <andreas.zeugswetter@telecom.at>

From: Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>
To: "'pgsql-hackers@hub.org'" <pgsql-hackers@hub.org>
Date: 1998-02-20T11:02:52Z
Lists: pgsql-hackers
Since the copy statement is behaving differently than the normal select
stuff,
I think we should eighter introduce a new permission (name it copy or dump)
or include the copy into the rewrite system.

I would vote for the first and implement a new command: 
	unload to <filename> [delimiter '|'] <select statement>;    -- and
	load from <filename> [delimiter '|'] <insert statement>;
that does behave like the select.      (please forgive my Informix
background)

As to the topic with setuid triggers and others, I think setuid procedures
would be sufficient.
These are implemented in Informix with the following simple syntax:
create dba procedure ....

Andreas