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

Re: \Copy and "Copy With Headers" -- every day these bug me.

From: Sheldon Strauch <sstrauch(at)enova(dot)com>
To: John Abraham <jea(at)hbaspecto(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: \Copy and "Copy With Headers" -- every day these bug me.
Date: 2012-02-15 17:41:17
Message-ID: B6BBAF6F-B50A-46F8-8910-1DE550275E06@enova.com (view raw or flat)
Thread:
Lists: pgadmin-support
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
> jea(at)hbaspecto(dot)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(at)postgresql(dot)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
sstrauch(at)enova(dot)com



In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2012-02-15 18:01:15
Subject: Re: \Copy and "Copy With Headers" -- every day these bug me.
Previous:From: John AbrahamDate: 2012-02-15 17:36:10
Subject: \Copy and "Copy With Headers" -- every day these bug me.

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