sqlpostgresqlautocompleteadd-onred-gate-sql-prompt

Redgate SQL Prompt equivalent for PostgreSQL database

I'm starting at a new company after coming from a previous role where I could rely on Redgate's SQL Prompt with a MySQL environment. I'm now working with a Postgresql environment (SQL Workbench/J) and was wondering if anyone had come across any similar programs for Postgresql to make the query writing a bit less tedious and time intensive.

I'm aware of the CNTRL + Space option for suggesting columns/tables, hoping for something that automatically prompts.

Thanks!

Solution

  • A full-featured GUI tool for PostgreSQL is pgAdmin.

    Among many other useful features, it has a query tool with code completion and suggestion.