3 ms·
I know you can already do that with the `COPY FROM` statement in Postgres but I always think it is a pain because you need physical access, need the files to be
by morgenkaffee 11y ago
I know you can already do that with the `COPY FROM` statement in Postgres but I always think it is a pain because you need physical access, need the files to be 100% correct and you have no progress indication.
If you need a more sophisticated solution you can look at pgloader. http://pgloader.io/ http://pgloader.io/
- anarazel 11y ago> I know you can already do that with the `COPY FROM` statement in Postgres but I always think it is a pain because you need physical access, Nope, there's COPY ... FROM STDIN which accepts data inline, over a normal connection.
- elchief 11y agoYou can use `\COPY` in PSQL remotely and without superuser privileges