How to import CSV into potsgresql table if not superuser
I am trying to copy a csv file into a postgresql table. Since I am not a superuser (and cannot get the superuser password), I cannot do this unless I use stdout or stdin. But here's a little problem, I don't know how to do it either. Also, I read that the file should be accessible to the database server, but I don't know how to make the file available to the database server.
+3
thecoparyew
source
to share
1 answer
Use psql
\copy
instead COPY
.
PgAdmin-III has an equivalent import option for the table.
See many (many) SO related questions here for details.
+2
Craig ringer
source
to share