Re: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2

From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
To: Brian Minton <bminton(at)efn(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2
Date: 2002-11-23 18:37:03
Message-ID: 3DDFCACF.7030907@intransa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I also think as a DBA or DB Power user you got to learn a command line
version of
something.....

Consider the following basic feature....

psql -c "some SQL query"

You can now put a simple script around it for ad hoc programming and
tools dev... in 20 seconds
or less....

Brian Minton wrote:

>
>> before you go off looking for a fancy GUI (there are a few, pgaccess,
>> pgadminII, etc...) try using psql from the command line. It's one of
>> the finest command line interfaces I've seen for any database, and
>> it's quite easy to learn.
>
>
> I agree that the command line psql is really easy, and the readline
> support is very nice. Don't know what that means? try entering some
> commands then hit the up arrow key. As for a gui, I reccomend
> phppgadmin, although setting it up is a little more complex, since it
> involves setting up a web server and php, but it is pretty nice.
> pgaccess is pretty straightforward and easy to use as well.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Medi Montaseri 2002-11-23 18:46:59 Re: Changing the type of a column in an already populated
Previous Message Oliver Elphick 2002-11-23 17:05:36 Re: Avoiding a race condition