Front End Viewing Application for PostgreSQL?

[Carlosinfl]

I am using PostgreSQL to hold my entire I.T. inventory for my company. I am manually entering the data in via hand through the Linux command line and the 'psql' utility which is great for me but other co-workers in I.T. have no understanding of how to view the schema and I wanted to see if anyone had any recommendations for software or applications I could use that would display all my PostgreSQL data to them over the web of sorts? Something that lets them view the warranty expiration dates I entered in the Dell table. I don't want an administrative tool like 'phppgadmin' or anything but more like a utility that users can go in and view the database schema and data for reference only.

 

[/dev/null]

I am using PostgreSQL to hold my entire I.T. inventory for my company. I am manually entering the data in via hand through the Linux command line and the 'psql' utility which is great for me but other co-workers in I.T. have no understanding of how to view the schema and I wanted to see if anyone had any recommendations for software or applications I could use that would display all my PostgreSQL data to them over the web of sorts? Something that lets them view the warranty expiration dates I entered in the Dell table. I don't want an administrative tool like 'phppgadmin' or anything but more like a utility that users can go in and view the database schema and data for reference only.

Do they have access?

Why not install an ODBC driver & link that into MS Access?

 

[Carlosinfl]

We use OpenOffice.org (no Microsoft Office) and I tried installing the 'postgres' driver from the Org site and it still fails.

 

[cleric_retribution]

This should work nicely for you: http://www.pgadmin.org/

 

[Carlosinfl]

This should work nicely for you: http://www.pgadmin.org/

Thanks but that tool is great for people who want to connect and create / edit a database in a hurry (or just lazy) but this doesn't allow office users who have no pro efficiency in DBA to view the database contents for reference.

 

[cleric_retribution]

how about a PHP front-end? You could write some quick code to pull the data from the DB based on terms entered by the non-technical users...

 

[Carlosinfl]

how about a PHP front-end? You could write some quick code to pull the data from the DB based on terms entered by the non-technical users...

Do you know if there are any online examples I can copy / use / modify from because I can hardly write basic HTML pages let alone PHP pages.