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.


source to share

1 answer

Use psql


instead COPY


PgAdmin-III has an equivalent import option for the table.

See many (many) SO related questions here for details.



All Articles