Re: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2

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@postgresql.org