DreamCoder for PostgreSQL (FREE PostgreSQL Tool)
This is a list of our users' most frequently asked questions. By answering them we hope to clarify any doubts they may have regarding DreamCoder for PostgreSQL.
What is DreamCoder for PostgreSQL?
DreamCoder for MySQL is a comprehensive tool for developing and managing PostgreSQL database servers. The product has a graphic interface which makes development and administration tasks easier, such as creating users, managing permissions, monitoring users, export data, report generation, graphical building of queries and data synchronization and structure among others.
What is the difference between the Freeware and the Enterprise versions?
The main difference between the commercial and the freeware versions are the features included. The freeware version has limited functionality. DreamCoder for PostgreSQL Freeware is suitable for beginners and people who do not need advanced options. To learn about features included in these two versions we recommend reviewing the comparison section.
It is possible to evaluate DreamCoder for PostgreSQL Enterprise before purchasing?
Yes, you can download a 100% functional version of the product and evaluate it for a period of 30 days, plus free access to our technical support channels.
If my database is on a Linux server and I work on a Windows computer, can I use the DreamCoder for PostgreSQL?
Yes, DreamCoder for PostgreSQL is independent of the OS where the PostgreSQL database server is installed, but keep in mind that DreamCoder for PostgreSQL works only in Windows environments.
Does DreamCoder for PostgreSQL support PostgreSQL 8,3?
Yes, DreamCoder for PostgreSQL works with the latest version of PostgreSQL database server.
Does the SQL editor have an autocomplete feature?
Both the SQL and the stored procedures editors have autocomplete, objects description, open object, format SQL code and many other features to make development easier for editors.
The main options available in the editors are:
Autocomplete: CTRL + SPACE
Object description: CTRL + CLICK
Open object: F4
Autocomplete special: CTRL + J
SQL code formatting: SHIFT + CTRL + F
Can I export my entire database?
You can perform a full export of the database, as well as export a group of objects or data.
Is there an option to build graphical queries for the database?
Yes, DreamCoder for PostgreSQL Enterprise has a modern query builder to easily build more complex queries, without previous SQL language knowledge.
Is there an option to graphically build insert, delete or updates for tables?
The product has an option to generate code to handle tables, this option can be called from the object browser or from the tools menu "generate SQL table."
If I have two equal databases with different records, can I synchronize them?
Yes, DreamCoder for PostgreSQL Enterprise has an option for synchronizing data. You can find this option on the Tools menu, "Database Data Synchronization". The only condition is that the tables are physically equal.
If I have two different structure databases, can I synchronize them?
Yes, DreamCoder for PostgreSQL Enterprise has an option for synchronizing the structure of two databases. You can find this option is available on the Tools menu, "Database structure synchronization”.
Can I monitor the users who are connected to my PostgreSQL database server?
DreamCoder for PostgreSQL has a monitor feature where you can view the activity of each user on your PostgreSQL database server.
I have a table that takes a long time to open, how is this possible?
If the table has many columns and these are fields with large values, the product may take some time formatting before showing it on the grid view. To speed up this process you can disable the option "columns best fit", it is available in the interface options, in the grid calling tab.
If the table has a large number of foreign keys and the “value list for foreign keys” option is enabled, this can also affect performance. In this case you should only disable this option from the interface options in the call grid tab.
I have 1000 records in a table and the product only shows 50, why does this happen?
The product always shows records in blocks of 50 in the grid. If you want to view the last record, just press the navigation button called "last."
Is there an utility to test stored procedures?
The DreamCoder for PostgreSQL Enterprise includes a feature for quickly testing stored procedures. You can access this option by right-clicking on a stored procedure and then clicking "test".
Can I import data directly from Excel into a table?
The Enterprise DreamCoder for PostgreSQL has a large number of options to handle, import and export data. One of them is a procedure by which the user just needs to copy data from Excel and then press the option called "paste records to grid ", available in the grid's advanced options, to insert data into the table in PostgreSQL. The Excel file must include the names of the columns being selected and copied.