On Wed, Dec 19, 2018 at 10:29 AM Devendra Yadav <devendra.857@xxxxxxxxx> wrote: > But the case is that, for it to happen it needs superuser permission which It only requires superuser permission if you ask the server to COPY a file from the local filesystem. Developers and programs should be using client libraries and feeding the data to be copied (in or out) to the server via the connection (which, for the server, is a stdin/stdout stream). psql provides this via \copy - other libraries have their own methods. David J.