Re: psql vs. pgadmin3 was:can't get UPDATE ... RETURNING ... INTO ... to compile successfully

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql vs. pgadmin3 was:can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Date: 2008-08-23 17:41:41
Message-ID: dcc563d10808231041m64fb4bc7hb9640870b40e2b7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Aug 23, 2008 at 10:28 AM, Ivan Sergio Borgonovo
<mail(at)webthatworks(dot)it> wrote:
> On Fri, 22 Aug 2008 18:34:53 -0600
> "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:
>
>> Glad you got your problem resolved. I have to admit I tend to
>> mostly use psql to interact with postgres. Nothing against
>> PGAdmin III, it's good software. I just tend to feel more comfy
>> scripting things than clicking things. Whether you're using
>> pgadmin III or psql, it's important that you have the right
>> version. For pgadmin it's usually best to always have the latest
>> version, and with psql the one that matches your db.
>
> Is there any secret I don't know?
> I mostly use pgadmin because:
> 1) It is easier to cut and paste code and results

I use /i /o a lot. poor man's cut and paste / multi-file buffer.
also highlight / middle button click.

> 2) It's easier to open several connections

I just use multiple term windows

> 3) you've the object structure to navigate

that's the main reason I'd find myself using it.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Balmer 2008-08-23 17:56:48 Re: psql vs. pgadmin3 was:can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Previous Message Tom Lane 2008-08-23 16:33:16 Re: AT TIME ZONE and DST in UTC<->CET conversion