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
thedatabase using the equivalent COPY .. FROM STDIN… With psycopg2 I also use COPY FROM STDIN to have the local
pythonapp feed the file to the postgres COPY command. In PGAdmin, however, to bulk load data into postgres we need to
copythe CSV file to the computer where the database resides and fiddle with permissions until the database can read the
fileusing 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
databaseCOPY 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
pastethem 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
jea@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
andgenerally prefer it to SQL Server Management Studio and other similar programs. So great work everyone. There are
justa couple of things...