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

Reply via email to