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


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


source







All Articles