1

I'm trying to upload a CSV file into Azure Postgresql. However when I run the command, I get the following error:

ERROR:  must be superuser to COPY to or from a file

However, Azure Postgresql doesn't allow users to be super users. How can I import the file?

Brig
  • 10,211
  • 12
  • 47
  • 71

1 Answers1

1

Have you tried the \copy command available in psql? I'm fairly sure it allows reading/ writing files local to the client and doesn't require you to be a superuser. See https://codeburst.io/two-handy-examples-of-the-psql-copy-meta-command-2feaefd5dd90

walkermatt
  • 338
  • 1
  • 3
  • 12