Re: PostgreSQL Frontend for Windows
От | Matthew Nuzum |
---|---|
Тема | Re: PostgreSQL Frontend for Windows |
Дата | |
Msg-id | 001b01c2e672$15caaee0$6900a8c0@mattspc обсуждение исходный текст |
Ответ на | Re: PostgreSQL Frontend for Windows (Jeff Davis <jdavis-pgsql@empires.org>) |
Список | pgsql-general |
A couple of suggestions for frontends... First, I think you were asking for a Linux front end, but the subject on your e-mail is confusing, so I'll recommend a few front ends I use in both Windows and Linux: First, the one I use the most is phpPgAdmin and it works in many web browsers. It lets you do some simple db/table management and do queries and reports. My favorite tool for doing queries and reports on Windows is MS Access. I currently use '97, but 2000 works just as good, if not better. You can easily make reports, queries and subqueries as well as mail merges and import/export data by linking or importing tables. For similar functionality on Linux, Staroffice or Openoffice.org can do just about everything Access can. It's not straightforward on how to do this though, but a link that might help is: http://www.linuxworld.com/2003/0207.barr.html (targeted at MySQL, but if you use the PostgreSQL ODBC driver instead, things work just as well. Alternately, the jdbc driver might be easier as you won't have to install ODBC on Linux) The follow up article is useful as well, http://www.linuxworld.com/2003/0217.barr.html. The important thing to remember about the Openoffice.org/Staroffice tools is while Microsoft created Access as a separate program, Openoffice.org integrates that functionality to varying degrees in ALL of it's productivity tools. Therefore, you do not have an icon for the database tools, you just create a new spreadsheet or word processor document and start going. If you want to do db management, I like pgAdminII on Windows and the tools for RedHat DB on Linux. I believe the RedHat tools are geared at Postgres 7.2 though, so no schemas. -- Matthew Nuzum www.bearfruit.org cobalt@bearfruit.org > -----Original Message----- > From: Jeff Davis [mailto:jdavis-pgsql@empires.org] > Sent: Saturday, March 08, 2003 4:09 PM > To: pgsql-general@postgresql.org > Subject: Re: PostgreSQL Frontend for Windows > > On Saturday 08 March 2003 10:15 am, Detlef Jockheck wrote: > > I'm using pgaccess on my linux-machine to access the postgresql db. Is > > there a similar frontend for linux? > > Perhaps I misunderstand your question, but I think you're looking for a > windows frontend for postgres. In that case, check out pgadmin at: > > http://pgadmin.postgresql.org/pgadmin2.php?ContentID=1 > > I believe that's the most full-featured, but there are also others. > > Regards, > Jeff Davis
В списке pgsql-general по дате отправления: