Skip site navigation (1) Skip section navigation (2)

Re: SQL Manager for PostgreSQL

From: Marcos Ortiz Valmaseda <mlortiz(at)estudiantes(dot)uci(dot)cu>
To: "Jorge A(dot) Barzola Rosadio" <jorgebarzola(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: SQL Manager for PostgreSQL
Date: 2009-02-21 23:02:39
Message-ID: 13256451.1312541235257359995.JavaMail.root@zimbra2.uci.cu (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Bueno, la mayoría de nosotros usa el PgAdmin III, con el cual muchos nos sentimos identificados, además de que, por lo menos a mí,me sirve para todo lo que quiero hacer. Pero, en caso de que no quieras usarlo en la wiki de PostgreSQL existe una descripción de las herramientas GUI disponibles para el gestor, divididas por la categoría de libres y propietarias. 
Aquí está el link:http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools 

Te dejo la descripción de las libres (No uso software propietario desde hace 4 años) 
pgAdmin III 


http://www.pgadmin.org/ 

MS Windows, GNU/Linux, FreeBSD, Mac OS X, OpenBSD, Solaris 

Admin 

pgAdmin III is THE Open Source management tool for your PostgreSQL databases. Features full Unicode support, fast, multithreaded query and data editting tools and support for all PostgreSQL object types. 

pgAdmin III is bundled with the Windows installer, and you can use that such a client to administer a remote server on another OS. Note that binary packages for platforms like RPM don't show up in every point release, you currently have to go back to v1.8.0 to get the last full set of packages. 

Free Administration Centre for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor and much more. pgAdmin III is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. Available in more than 30 languages and for several operating systems. (2005-04-19) PGAccess 


http://www.pgaccess.org 

Most platforms 

ERD 

The original PostgreSQL GUI, with an MS Access-style database browser, written in Tcl/Tk. Allows browsing, adding and editing tables, views, functions, sequencese, databases, and users, as well as graphically-assisted queries. A form and report designer are also under development by the PGAccess team, who could use help from some more Tcl/Tk coders and doc writers. (JMB 11.2002) phpPgAdmin 


http://sourceforge.net/projects/phppgadmin 

browser-based, requires webserver 

Admin 

Similar to the ever-popular phpMyAdmin, enhanced for PostgreSQL, supports browsing and modification of most types of PostgreSQL database objects, plus execution of ad-hoc queries. Maintained by (who else?) the phpPgAdmin team. (JMB 11.2002) OpenOffice.org 


http://www.openoffice.org 

Windows, Linux, Solaris 

ERD 

Open Source office suite with limited database browsing through "Data Sources" interface. Can create moderately complex reports and simple data entry forms. Currently requires ODBC or UnixODBC?, but a "native" PostgreSQL driver is under development. Under development by the OpenOffice.org DBA team (dba.openoffice.org) who could use some new members. (JMB 11.2002) The Red Hat Database Graphical Tools, RHDB Administrator and Visual Explain 


http://sources.redhat.com/rhdb 

Linux 

Admin 

Red Hat has stood by their word and open-sourced their database tools which ship with Red Hat Database for the benefit of the PostgreSQL community. I haven't used these, a review would be nice. Developed by Red Hat, Inc. (JMB 11.2002) Xpg: Java PostgreSQL client 


http://www.kazak.ws/xpg 

Most platforms 

Admin 

Java-based PostgreSQL database administrator, with access to tables and data entry, query interface and ability to export query results to HTML reports. Developed by Soluciones Kazak, in Spanish, but available in English as well. (JMB 11.2002) Mergeant 


http://www.gnome-db.org 

Linux, Unix 

Admin 

Database administration/user tool for GNOME, based on libgda/libgnomedb, which are a complete database-independent access layer for UNIX systems, with support for PostgreSQL, MySQL, Sybase, MS SQL Server, Oracle, Interbase/Firebird, MS Access files, xBase. TOra, an Oracle tool with some PostgreSQL support 


http://tora.sf.net./ 

Linux & Windows 

Admin 

An Oracle database administration interface, with limited ability to browse PostgreSQL databases (tables, views, and functions only). I'm told that if you have the Oracle libraries, Tora's sophisticated function editor will work for PostgreSQL as well. Developed by Henrik Johnson as a Quest Toad clone. (JMB 11.2002) KNoda 


http://www.knoda.org 

FreeBSD & Linux 

Admin 

knoda is a database frontend for KDE. It is based on hk_classes and is released under the GNU General Public License (GPL). PGInhaler 


http://pginhaler.ifrance.com/pginhaler/ 

Admin 

It's a free Java based PostgreSQL GUI. Haven't used it yet, but worth knowing about. (J.C.) 


SQuirreL 


http://squirrel-sql.sourceforge.net/ 

Macintosh/Windows 

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. AnySQL Maestro 


http://www.sqlmaestro.com/products/anysql/maestro/ 

Windows 

AnySQL Maestro is a freeware tool for administering any database engine (PostgreSQL, SQL Server, Oracle, MySQL, MS Access, etc.), which is accessible via ODBC driver or OLE DB provider. Includes Database Designer, Visual Query Builder, BLOB Viewer/Editor, SQL Editor, Data export/import and other features. PostgreSQL PHP Generator 


http://www.sqlmaestro.com/products/postgresql/phpgenerator/ 

Windows 

PostgreSQL PHP Generator is a freeware but powerful PostgreSQL GUI frontend that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web. 
----- Mensaje original ----- 
De: "Jorge A. Barzola Rosadio" <jorgebarzola(at)gmail(dot)com> 
Para: "PostgreSQL" <pgsql-es-ayuda(at)postgresql(dot)org> 
Enviados: Sábado, 21 de Febrero de 2009 14:12:50 (GMT-0500) Auto-Detected 
Asunto: [pgsql-es-ayuda] SQL Manager for PostgreSQL 

Existe una herramienta similar o mejor que SQL Manager for PostgreSQL 2007, ya que se acaban los 30 dias de prueba. 

-- 
Jorge A. Barzola Rosadio 

Lima - Perú 


-- 

¨¨Tip 9 : Vacumm es tu amigo.......¨¨¨ 
Marcos Ortíz Valmaseda 
Linux User # 418229 
PostgreSQL 8.3.5 && Debian GNU/Linux Experimental User 


pgsql-es-ayuda by date

Next:From: Gabriel Hermes Colina ZambraDate: 2009-02-22 05:11:04
Subject: Re: SQL Manager for PostgreSQL
Previous:From: Marcos Ortiz ValmasedaDate: 2009-02-21 22:54:18
Subject: Re: Backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group