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
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 |