Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2

Hi Jay,

There are a bunch of GUI options for PostgreSQL, it just depends on what
you're after.

The PostgreSQL 7.2 stuff that comes with Mandrake 9.0 is probably best
described as the pure "database engine" that runs in the background.
The part that just holds data, processes it, etc.

Whilst you can do stuff with the database engine directly from
applications, and from the command-line utilities that it comes with, if
you're used to using a GUI then it might be best to grab one and install
it.

So, the next question is, any idea what you're looking to do with the
GUI, so we can recommend one that does that?

:-)

Regards and best wishes,

Justin Clift

"QUINN, JAY (SBCSI)" wrote:

Ok, I went and bought Mandrake Linux 9.0 today, it has Postgresql 7.2.
Where is Postgresql in this OS? I can see it via ps -ef|grep post*, and
when it loads up on boot and stops when it shuts down. But I can't find the
icon or where it resides in the GUI to start/run or use it. Help! Thanks,
Jay

Jay Quinn - Sr. Data Analyst
Enterprise Data Warehouse
http://edw.sbc.com/
http://esis.sbc.com
Desk (214) 576-7163

"This e-mail and any files transmitted with it are the property of SBC,
are confidential, and are intended solely for the use of the individual or
entity to whom this e-mail is addressed. If you are not one of the named
recipient(s) or otherwise have reason to believe that you have received
this message in error, please notify the sender at (214) 576-7163 and
delete this message immediately from your computer. Any other use,
retention, dissemination, forwarding, printing, or copying of this e-mail
is strictly prohibited."

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

On Wednesday 20 November 2002 23:59, Justin Clift wrote:

There are a bunch of GUI options for PostgreSQL, it just depends on what
you're after.

As to GUI's, there are a couple of closed-source options available from
theKompany: Rekall, and DataArchitect. Rekall is a front-end package with
full scripting in python -- something like Access. DataArchitect is a
designers tool -- it does ERD design work, and can reverse-engineer to an ERD
from a database. While Rekall is closed source, you get the source under a
distribution-restricted license. DataArchitect is traditional commercial
software. Both work on Win32 and Linux.

www.thekompany.com
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Install the postgresql-tk rpm. This installs the pgAccess application
which you will find in the K menu (assuming KDE) under
Applications/Database.

Are there any freebies out there?

-----Original Message-----
From: Lamar Owen [mailto:lamar.owen@wgcr.org]
Sent: Wednesday, November 20, 2002 11:30 PM
To: Justin Clift; QUINN, JAY (SBCSI)
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2

On Wednesday 20 November 2002 23:59, Justin Clift wrote:

There are a bunch of GUI options for PostgreSQL, it just depends on what
you're after.

As to GUI's, there are a couple of closed-source options available from
theKompany: Rekall, and DataArchitect. Rekall is a front-end package with
full scripting in python -- something like Access. DataArchitect is a
designers tool -- it does ERD design work, and can reverse-engineer to an
ERD
from a database. While Rekall is closed source, you get the source under a
distribution-restricted license. DataArchitect is traditional commercial
software. Both work on Win32 and Linux.

www.thekompany.com
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

On Wed, 20 Nov 2002, QUINN, JAY (SBCSI) wrote:

Ok, I went and bought Mandrake Linux 9.0 today, it has Postgresql 7.2.
Where is Postgresql in this OS? I can see it via ps -ef|grep post*, and
when it loads up on boot and stops when it shuts down. But I can't find the
icon or where it resides in the GUI to start/run or use it. Help! Thanks,
Jay

Jay Quinn - Sr. Data Analyst
Enterprise Data Warehouse
http://edw.sbc.com/
http://esis.sbc.com
Desk (214) 576-7163

"This e-mail and any files transmitted with it are the property of SBC,
are confidential, and are intended solely for the use of the individual or
entity to whom this e-mail is addressed. If you are not one of the named
recipient(s) or otherwise have reason to believe that you have received
this message in error, please notify the sender at (214) 576-7163 and
delete this message immediately from your computer. Any other use,
retention, dissemination, forwarding, printing, or copying of this e-mail
is strictly prohibited."

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.

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.

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: