Re: Beginner Programming Question - Mailing list pgsql-interfaces

From Andreas Kretzer
Subject Re: Beginner Programming Question
Date
Msg-id 3CC520A2.4048D84F@kretzer-berlin.de
Whole thread Raw
In response to Beginner Programming Question  ("Jeff Flowers" <jeffrey@jeffreyf.net>)
List pgsql-interfaces
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



pgsql-interfaces by date:

Previous
From: lexx_h@chat.ru
Date:
Subject: Re: getting value of just inserted rows
Next
From: ibs@netian.com
Date:
Subject: How can I ld_library path set for lpq++ with FreeBSD ?