Online Documentation for SQL Query for PostgreSQL
EMS SQL Query FAQ
Please read this page attentively if you have questions about SQL Query for PostgreSQL.
Product questions
- What is EMS Query for PostgreSQL?
- What do I need to start working with EMS Query for PostgreSQL?
- What is the difference between the Query Builder module in SQL Manager for PostgreSQL and the standalone SQL Query application?
- Are there any limitations implied in the trial version as compared with the full one?
Troubleshooting
- I cannot figure out how I can use the Export dataset function. Why I press the Export Data toolbar button, nothing happens.
- I get the following error: 'ERROR: Query was canceled.' when I try to execute a query in SQL Editor or when I perform some operations with database objects.
- I use a UTF-8 database. Native characters are shown incorrectly in the query result. What is wrong?
- I’ve registered the DB, but on attempt to connect the "dynamic library libpq.dll not found" message appears.
Question/answer list
Product questions
Q: What is EMS Query for PostgreSQL?
A: EMS SQL Query for PostgreSQL is a utility that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual building as well as direct editing of a query text are available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and much more. You can work with several queries at once, edit queries and view the execution results in one of the available modes and perform any other operations you may need in your work with database queries.
Q: What do I need to start working with EMS SQL Query?
A: First of all, you must have a possibility to connect to some local or remote PostgreSQL server to work withSQL Query. You can download PostgreSQL database server from https://www.postgresql.org/download/ (download is free). Besides, you need your workstation to satisfy the system requirements of SQL Query for PostgreSQL.
Q: What is the difference between the Query Builder module in SQL Manager for PostgreSQL and the standalone SQL Query application?
A: First of all, SQL Query for PostgreSQL works faster as it is a considerably lighter application. Besides, it provides additional features for query building, namely:
- "favorite" queries to find and execute often used queries quickly;
- saving query history which allows you to rollback to any of the previous queries;
- various interface improvements for easier and more productive work.
Q: Are there any limitations implied in the trial version as compared with the full one?
A: Actually the trial version of the utility does not differ from the full version as far as the functionality is concerned. That is, you can test all the features implemented in SQL Query for PostgreSQL within the 30-day trial period.
Troubleshooting
Q: I cannot figure out how I can use the Export dataset function. Why I press the Export Data toolbar button, nothing happens.
A: Please make sure that you have the latest version of EMS Data Export for PostgreSQL installed on your system. Note that the export utility should be registered and run at least once before you use the Exporting results function.
Q: I get the following error: 'ERROR: Query was canceled.' when I try to execute a query in SQL Editor or when I perform some operations with database objects.
A: You need to increase the SQL TimeOut value within the Preferences tab of the Environment Options dialog, or set it to 0 (unlimited).
Q: I use a UTF-8 database. Native characters are displayed incorrectly in the query result. What is wrong?
A: You need to set Client encoding in the Database Registration Info dialog.
Q: I've registered the DB, but on attempt to connect the "dynamic library libpq.dll not found" message appears.
A: Please, make sure that the libpq.dll file exists in the program directory. Reinstallation of the application may solve the problem.
If you still have any questions, contact us at our Support Center.
