I executed a
CREATE ROLE statement to create a standard account named gpuser01 in AnalyticDB for PostgreSQ.
However, when I executed a COPY statement to copy a script as the gpuser01 user, the
system displayed "
ERROR: must be superuser to COPY to or from a file."
How do I promote a standard account to the superuser user?
- AnalyticDB for PostgreSQL does not support the superuser user. For more information, see Features and limits.
- You can copy data to a file by executing:
psql -c 'copy xx to stdout' > file
cat file | psql -c 'copy xx from stdin'