On Feb 15, 2012, at 11:36 AM, John Abraham wrote: > These are two things that bug me every single day: > > 1) "\copy" equivalent. 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. > > 2) copy with headers. I use this every day on SQL Server Management Studio > to select data and copy them out, then paste them into another app (usually > Excel.) With PGAdmin I select and copy the data, paste them into Excel, then > *manually* type the column headers. > > I think both of these should be easy to implement, so I hope they can be > implemented. > > -- > John Abraham > j...@hbaspecto.com > > PS when I say "every single day" I mean a lot of days, probably over 250 days > per year. Yes I use PGAdmin all the time and generally prefer it to SQL > Server Management Studio and other similar programs. So great work everyone. > There are just a couple of things... > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support
+1 from me. This would allow us to jettison a competing commercial tool that causes us pain. Sheldon E. Strauch Manager, Database Development sstra...@enova.com
