#355: "\copy" equivalent
---------------------+------------------------------------------------------
Reporter: gleu | Owner: dpage
Type: feature | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: trunk
Keywords: browser | Platform: all
---------------------+------------------------------------------------------
psql has \copy to copy from a local file. Using the JDBC driver I also
often copy data into the database using the equivalent COPY .. FROM STDIN…
With psycopg2 I also use COPY FROM STDIN to have the local python app feed
the file to the postgres COPY command. In PGAdmin, however, to bulk load
data into postgres we need to copy the CSV file to the computer where the
database resides and fiddle with permissions until the database can read
the file using COPY. This should be easy to implement, it wasn't hard
for me to do it with both psycopg2 and with the JDBC driver, and psql has
had it for years. The application (PGAdmin) needs to open the file and
then feed the stream to the database COPY command as STDIN.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/355>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III