Re: [pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread Guy Rouillier
On 2/15/2012 1:01 PM, Guillaume Lelarge wrote: On Wed, 2012-02-15 at 10:36 -0700, John Abraham wrote: 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

Re: [pgadmin-support] truncate multiple tables doesnt work

2012-02-15 Thread Guillaume Lelarge
On Wed, 2012-02-15 at 20:34 +, Dave Page wrote: > On Wed, Feb 15, 2012 at 8:34 PM, Guillaume Lelarge > wrote: > > On Wed, 2012-02-15 at 20:31 +, Dave Page wrote: > >> On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge > >> wrote: > >> > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote

Re: [pgadmin-support] truncate multiple tables doesnt work

2012-02-15 Thread Dave Page
On Wed, Feb 15, 2012 at 8:34 PM, Guillaume Lelarge wrote: > On Wed, 2012-02-15 at 20:31 +, Dave Page wrote: >> On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge >> wrote: >> > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote: >> >> I have pgadmin3 1.14.1 and postgresql 9.1, when I select

Re: [pgadmin-support] truncate multiple tables doesnt work

2012-02-15 Thread Guillaume Lelarge
On Wed, 2012-02-15 at 20:31 +, Dave Page wrote: > On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge > wrote: > > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote: > >> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables, > >> right click and select truncate, it trunca

Re: [pgadmin-support] truncate multiple tables doesnt work

2012-02-15 Thread Dave Page
On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge wrote: > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote: >> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables, >> right click and select truncate, it truncates only one table at a time. > > You cannot select more than

Re: [pgadmin-support] truncate multiple tables doesnt work

2012-02-15 Thread Guillaume Lelarge
On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote: > I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables, > right click and select truncate, it truncates only one table at a time. You cannot select more than one object in the browser. -- Guillaume http://blog.guillaume.l

[pgadmin-support] truncate multiple tables doesnt work

2012-02-15 Thread Andrew Chen
I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables, right click and select truncate, it truncates only one table at a time.

Re: [pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread Guillaume Lelarge
On Wed, 2012-02-15 at 19:54 +0100, Guillaume Lelarge wrote: > On Wed, 2012-02-15 at 11:11 -0700, John Abraham wrote: > > > > On Feb 15, 2012, at 11:01 AM, Guillaume Lelarge wrote: > > > > > If I'm correct, what you want is that, when you paste into Excel, > > > there > > > would be some kind of a

Re: [pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread Guillaume Lelarge
On Wed, 2012-02-15 at 11:11 -0700, John Abraham wrote: > > On Feb 15, 2012, at 11:01 AM, Guillaume Lelarge wrote: > > > If I'm correct, what you want is that, when you paste into Excel, > > there > > would be some kind of automatic typing of columns. I don't see that > > as > > "easy to implement

Re: [pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread John Abraham
On Feb 15, 2012, at 11:01 AM, Guillaume Lelarge wrote: > If I'm correct, what you want is that, when you paste into Excel, there > would be some kind of automatic typing of columns. I don't see that as > "easy to implement" for three reasons: No sorry you misunderstand. I just want an additiona

Re: [pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread Guillaume Lelarge
On Wed, 2012-02-15 at 10:36 -0700, 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 ps

[pgadmin-support] \Copy and "Copy With Headers" -- every day these bug me.

2012-02-15 Thread John Abraham
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 f

Re: [pgadmin-support] saved passwords deleted

2012-02-15 Thread Michael Shapiro
I have taken to making a copy of the password file so that when the connection fails and PgAdmin removes the password, I can put it back. On Wed, Feb 15, 2012 at 4:27 AM, Vik Reykja wrote: > On Tue, Feb 14, 2012 at 22:45, Guillaume Lelarge > wrote: > >> You can connect without saving the passwo

Re: [pgadmin-support] saved passwords deleted

2012-02-15 Thread Vik Reykja
On Tue, Feb 14, 2012 at 22:45, Guillaume Lelarge wrote: > You can connect without saving the password: let the "Save password" > checkbox unchecked. > Sure, but then I'd have to enter it in every time. That's not what I want. I want it to not forget the password just because there was a connect