Postgres COPY TO / FROM A FILE as non superuser

Question

im trying to create a function that any user can call in order to copy data from/to a file... my idea is to set a function that acts as a superuser or one that is executed as "postgres" but I dont know were to start to begin with.

Can anyone point me in the right direction?

Richard Huxton · Accepted Answer · 2013-11-28 15:04:19Z

4

You're looking for "SECURITY DEFINER". See docs for details http://www.postgresql.org/docs/9.3/static/sql-createfunction.html

answered Nov 28, 2013 at 15:04

Richard Huxton

23.6k5 gold badges43 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Solrac Over a year ago

That's awesome, thanks. Do you know if its possible to pass table, fields and file path as extensions to a function? lets say: COPY $table ($fields) FROM $path with csv; BTW I'm using postres 8.4 and testing as I write this :P

Richard Huxton Over a year ago

You'll want to use EXECUTE and also do some validation on your parameters.

Solrac Over a year ago

Thanks I think I can find my way from here ;)

Collectives™ on Stack Overflow

Postgres COPY TO / FROM A FILE as non superuser

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related