Redgate SQL Prompt equivalent for PostgreSQL database
A full-featured GUI tool for PostgreSQL is pgAdmin.
Among many other useful features, it has a query tool with code completion and suggestion.
You can use the dbForge Studio for PostgreSQL software to meet your needs, and this will help you to use this software in accordance with what is in the SQL Prompt program.I hope the explanation I gave was useful to you.