The name pretty much says it all. Right now I'm using Squirrel - it crashes frequently and suffers from memory problems (I've tried increasing the heap size). I don't need anything particularly fancy or full-featured - just something that won't take up 2.4 GB of RAM to store a 1.5 million line, 8 column result set.
alexalex
Aug 10, 2018 If you're building a complicated data model, support from tools that provide for the creation of Entity-Relationship diagrams and similar techniques are extremely useful.
5 Answers
Use PgAdmin.
However - I don't think you'll find much that won't use a large amount of memory when you have a result set with 1.5 million rows...
PgAdmin has the ability to limit automatically the number of rows returned - so you can get an overview, but not sit for an hour waiting for your results to turn up. If you write a query to return that many rows though, than you are going to have problems.
(You can also look at the
limit
SQL command, to restrict how many results you get back)RodeoClownRodeoClown
Try official pgAdmin.http://www.pgadmin.org/download/windows.php
jozefsevcikjozefsevcik
One option would be to use phpPgAdmin on the server. It’s a web app, but it’s lightweight and easy to install.
It can paginate results, so it can handle large result sets. It can’t do everything that pgAdmin can do, but for everyday use I prefer it.
NateNate
NOTE: This is the same answer I gave this duplicate question.
I recommended dbVis. The client runs on Mac, Windows and Linux and supports a variety of database servers, including PostgreSQL.
Community♦
jwfearnjwfearn
![Free postgresql guides Free postgresql guides](http://cdn.networkice.com/gen_screenshots/en-US/windows/navicat-postgresql-gui/large/scr_1370072590-700x500.png)
HeidiSQL has experimental support for postgres. I find HeidiSQL much easier to use than pgAdmin.
SawnySawny
Not the answer you're looking for? Browse other questions tagged postgresqlclient or ask your own question.
SQL Maestro Group /Products /PostgreSQL /PostgreSQL Maestro
Complete and powerful database management, admin and development tool for PostgreSQL. |
Detailed info
Easy database object management Browse, create, edit, duplicate, rename and drop all schema objects like tables, views, functions or triggers in the simplest way possible. |
Database Designer Simplify your data modeling tasks. Create tables and relations in a few mouse clicks. Print diagrams or export them to a number of graphical file formats. |
Data management and analysis tools Browse, edit, print, sort, group and filter your data using wide spectrum of available tools including master-detail views. Build graphical diagrams and OLAP cubes. |
SQL Editor and Visual Query Builder Enjoy feature-rich SQL Editor with code completion, code folding and SQL formatter or build your queries visually. |
Data export and import tools Export your data to as many as 20 most popular file formats or import data from Excel, CSV, XML and other files. |
Security management tools Make your server safe and secure with powerful tools provided by PostgreSQL Maestro. |
Schema refactoring tools Split denormalized tables, generate DML procedures or updatable views and check nullable columns with a few mouse clicks. |
BLOB management tools View and edit contents of BLOB fields in your database as hexadecimal, text, image, HTML, or PDF. Export/import BLOBs to/from external files. |
PL/pgSQL Debugger Debug your PL/pgSQL functions using traditional debugging features such as setting breakpoints, viewing variable values, and examining the call stack. |
Related solutions
SQL Maestro for MySQL A complete and powerful database management and development tool for MySQL and MariaDB. | ||
MS SQL Maestro A comprehensive IDE for all DBAs and developers. Use it to manage any SQL Server from 7.0 to 2017 and Azure SQL Database! | ||
Firebird Maestro Complete Firebird management IDE combining user-friendly interface with the latest Firebird 2.1, 2.5, and 3.0 features support. | ||
SQLite Maestro Makes SQLite database management even more easier than one can imagine. | ||
Oracle Maestro Your best guide in the world of Oracle. | ||
PostgreSQL Data Wizard Various PostgreSQL data management tools with a flexible task scheduler. | ||
PostgreSQL PHP Generator Builds full-fledged web database applications in a few mouse clicks. | DownloadFree * | |
PostgreSQL Database Converter Migrates any database to PostgreSQL in just five simple steps. | ||
PostgreSQL Data Sync Compares PostgreSQL database contents and synchronizes differences. | ||
See all products |
Top 10 reasons to use PostgreSQL Maestro
Latest PostgreSQL versions support PostgreSQL Maestro supports all the latest versions of PostgreSQL server |
![Free Postgresql Gui Free Postgresql Gui](/uploads/1/2/5/3/125312997/621520482.png)
Use PostgreSQL Maestro to administer any PostgreSQL server version from 7.3 to 10! PostgreSQL Maestro supports latest server version features such as PL/pgSQL Debugger, role system, parameter scopes, connection limits, tablespaces, changing column types, dollar-quotation, Unicode data and much more.
Powerful security management PostgreSQL security system is easy and clear in PostgreSQL Maestro |
Tune up your PostgreSQL server security policy with several mouse clicks. PostgreSQL Maestro provides you with a number of powerful GUI editors that make management of Postgres users, roles and their privileges (grants) as easy as it can be, even if you are not a skilled PostgreSQL administrator.
Easy database objects management PostgreSQL Maestro is incredibly easy in database objects management |
As PostgreSQL client for Windows, PostgreSQL Maestro lets you use Windows clipboard, drag-and-drop operations, and local pop-up menus for database objects. For example, to copy an object, simply drag and drop the object from one database to another, or use the Ctrl+C and Ctrl+V shortcuts instead of performing a long succession of manual operations.
Clear in use Even a newbie can use PostgreSQL Maestro admin tool |
PostgreSQL Maestro GUI is as easy in use as Windows explorer! PostgreSQL Maestro provides you with an understandable 'explorer-like' navigation style, well-described wizard system, quick launch panel and a lot of other tools and features which do not require deep knowledge of PostgreSQL.
Advanced SQL Editor PostgreSQL Maestro manager allows you to create and execute queries in the most convenient way |
Handy SQL Editor provides you with an ability to execute several queries simultaneously. Each query is executed in a separate thread, so all PostgreSQL Maestro opportunities remain available and there is no need to wait for your complex query to be completed. Such features as syntax highlighting and code completion make your work with the Editor extremely comfortable.
Powerful data export and import PostgreSQL Maestro provides you with advanced data export and import abilities |
PostgreSQL Maestro supports more than twelve formats for data export and six formats for data import. These are MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, CSV, DBF and more. Moreover, the Postgres client does not require any additional software installed for all the supported formats.
Full support for BLOB fields PostgreSQL Maestro has an ability to view BLOB data in various ways |
Using PostgreSQL Maestro manager you can view or edit BLOB data in the following ways: hexadecimal dump, plain text, graphical image, HTML page, or PDF document. A graphical representation of BLOB data supports five image formats: BMP, Windows metafile, JPEG, GIF and PNG.
Viewing data as diagrams PostgreSQL Maestro allows you to build diagrams based on PostgreSQL data |
This exclusive feature represents numeric data from a table or a query result as a diagram with a possibility of customizing its appearance in various ways. You can also easy export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more.
The fastest way for building queries PostgreSQL Maestro allows you to create the SELECT statements visually |
The Visual Query Builder is a powerful tool of PostgreSQL Maestro intended for designing queries as visual diagrams. This tool does not require any knowledge of the SELECT statement syntax, it will form a query automatically, you just need to mark what information do you want to retrieve.
Full customization according to your preferences and needs PostgreSQL Maestro admits to flexible customization |
In PostgreSQL Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other various preferences.