Message-ID: <3CC520A2.4048D84F@kretzer-berlin.de>
Date: Tue, 23 Apr 2002 10:51:46 +0200
From: Andreas Kretzer <andi@kretzer-berlin.de>
MIME-Version: 1.0
To: Postgres Interface List <pgsql-interfaces@postgresql.org>
Subject: Re: Beginner Programming Question
References: <000701c1e6fc$9f53c960$6501a8c0@test>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jeff Flowers wrote:

> I am planning on using PostgreSQL and I would like to have a command line
> frontend. I am just now learning C, so my question is: what is the best way
> for a novice to get started? libpgeasy seems cool but there doesn't seem to
> be much in the way of examples for it.
>
> Also, has anyone designed a front-end using a shell, such as Bash?

Use 'psql' !

It's a simple SQL query backend and the use is straight forward! I use it regularly
to manage bad entries (-> user fault which are not correctable from application side)
and to discover strange things which lead to errors in my application.

The first arg to psql is the database name. If you miss it, your database will be your
user name (if it doesn't exist it will fail). Read the manual or try the online help

BTW: I use Tcl/Tk for my applications. It's easy to use, provides a graphical frontend
and is portable between Linux and Windows.

Hope this helps
Andreas