Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".
Armin Braunstein: "Also I must say, that your PostgreSQL Maestro tool is the best tool for PostgreSQL I have seen. For general I am really happy about the tool and how it works".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Database Variables

There are a lot of configuration parameters that affect the behavior of the database system. All parameter (server variables) names are case-insensitive. Every such variable takes a value of one of four types: boolean, integer, floating point or string. For a PostgreSQL database you can specify values of the variables (different from values of the server variables).

 

 

To set a new database variable value use Database variable properties window. In order to open the window you should either

 

select the Object | Create Database Object... main menu item;
select the Variable icon in the Create Database Object dialog

or

select the Variables list or any object from that list in the explorer tree;
select the Add New Variable... item from the popup menu

or

open the database in Database Editor and the Variables tab there;
press the Insert key or select the Add New Variable... item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

 

 

 

Variables can be edited within Database Variable Properties window. In order to run the editor you should either

 

select the variable for editing in the explorer tree (type the first letters of the variable name for quick search);
select the Edit Variable ... item from the popup menu

or

open the database in Database Editor and the Variables tab there;
select the variable to edit;
press the Enter key or select the Edit Variable item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

 

 

 

To reset a database variable:

 

select the variable to drop in the explorer tree;
select the Drop Variable item from the popup menu

or

open the database in Database Editor and the Variables tab there;
select the variable to drop;
press the Delete key or select the Drop Variable item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

 

and confirm dropping in the dialog window.

 



Prev Return to chapter overview Next