On Mon, 2007-02-19 at 22:09 -0600, Sunny wrote:

On 2/19/07, Art Fore wrote:

...

Does anyone know of an opensource database frontend for Postgresql database along the lines of MSAccess? I have tried the following with no success

Rekall Try to open a table or view or even properties thereof, and it crashes. This is on Suse 10.2 with its Rekall from the dvdk.

Knode Cannot even do find/replace on fields, Menu items are there, but they don't work. ditto for OOoBase.

PgAdmin Cannot do find/replace. The latest version has the menu options for that, but it does not work. Apparently Wxwidgets that is based on is broken. Cannot do lower case to upper case conversions that I could find without taking a course in SQL.

Even Access has problems with ODBC, or maybe it is Windows. Open the postgres database on localhost using Access with ODBC and do the find/replace query, the convert 3 fields to uppercase. Close out Access, Change ODBC setup to look at remote host database. Open Access. It is still looking at the localhost database eventhough ODBC is pointing to remote host. Close Access, reboot WinXP (running under Parallels), then open Access again. Now it is finally looking at the correct database. Does not say much for Microsoft interoperability and they supposedly invented ODBC.

Art

I asked similar question about frontends for MSSQL. This is the thread in the archives, see if some of the proposed products will help you: http://lists.opensuse.org/opensuse/2006-11/msg03475.html

-- Svetoslav Milenov (Sunny)

Even the most advanced equipment in the hands of the ignorant is just a pile of scrap.

Thanks for the info. Am going to download both an evaluate. Art -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

On Mon, 2007-02-19 at 22:17 -0600, david rankin wrote:

...

From: "Art Fore" Does anyone know of an opensource database frontend for Postgresql database along the lines of MSAccess? I have tried the following with no success

Art

My only though would be to dump the database to ascii and read it (load data infile) in to mysql and then use mysql query browser and mysql admin. The query browser/administrator allows access style table browsing, etc. I haven't tried a global search/replace, but they are great for quick table fixes.

-- David C. Rankin, J.D., P.E. 510 Ochiltree Street Nacogdoches, Texas 75961 (936) 715-9333 (936) 715-9339 fax www.rankinlawfirm.com --

PgAdmin is fine for quick table fixed and making basic queries (views), and database administration, but that is about it. Art -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org