Skip site navigation (1) Skip section navigation (2)

[pgAdmin III] #355: "\copy" equivalent

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #355: "\copy" equivalent
Date: 2012-02-17 21:11:10
Message-ID: 045.65e678a9e7ba4bac41f5b19a80177802@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#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

pgadmin-hackers by date

Next:From: pgAdmin TracDate: 2012-02-17 21:11:37
Subject: Re: [pgAdmin III] #355: "\copy" equivalent
Previous:From: pgAdmin TracDate: 2012-02-17 21:09:50
Subject: [pgAdmin III] #354: truncate multiple tables doesnt work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group