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

Поиск
Список
Период
Сортировка
От Marc Balmer
Тема Re: psql vs. pgadmin3 was:can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Дата
Msg-id 20080823175648.GH11429@mail.msys.ch
обсуждение исходный текст
Ответ на psql vs. pgadmin3 was:can't get UPDATE ... RETURNING ... INTO ... to compile successfully  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Ответы Re: psql vs. pgadmin3 was:can't get UPDATE ... RETURNING ... INTO ... to compile successfully  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
* Ivan Sergio Borgonovo wrote:
> On Fri, 22 Aug 2008 18:34:53 -0600
> "Scott Marlowe" <scott.marlowe@gmail.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
> 2) It's easier to open several connections
> 3) you've the object structure to navigate

The pgadmin3 version I use has some annoying bugs:  If I want to
add privileges to an object, it does not show me all roles in
the corresponding drop down box.

I am using version 1.8.2.  Is that fixed in a newer version?

>
> But I miss psql auto completion.
>
> I know I can call an external editor that would make cut&paste
> easier in psql but I'll lose autocompletion and I've had some issues
> with pgadmin search&replace and regexp, so I definitively would
> enjoy psql more... but what about the rest?
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Garry Saddington
Дата:
Сообщение: query takes a long time
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: psql vs. pgadmin3 was:can't get UPDATE ... RETURNING ... INTO ... to compile successfully