Please enable JavaScript to view this site.

Creating PostgreSQL database copies

To a large extent, copying a database is the same thing as creating a new one...

Enter the alias of the new database.


A customer profile with the same name as the database alias is created automatically. Database aliases and customer profiles are managed with the Alias, Customer and Guest Manager.


Select PostgreSQL as your database server.        


Enter the name and password of the database administrator (DBA).

don’t confuse the DBA role with the administrator (”owner”) of the Efficy database


Case-sensitivity of PostgreSQL

PostgreSQL table names and field names are case-sensitive. In addition, the default is supposed to be lowercase, even though you can create table and fields with uppercase characters!


create a table test. The query select * from test works; so does the query select * from “test”

create a table MyTest. The query select * from MyTest doesn’t work; the query select * from “MyTest” does

Efficy queries for PostgreSQL don’t use quoted table, field (or other database element) names; the default lowercase cast functions properly.

The database tables and fields are created with lowercase names in the database. The PostgreSQL engine converts all SQL commands to lowercase versions.

Fill out the server-specific information:

oenter the host here the database is located.

oenter the port. The default port is 5432.

The listening port can be easily changed in the settings file postgresql.conf, the main configuration file for the database server.

oenter the name of the database.

oenter the default table space (it will contain all the data). efficy functions as default value.


Enter the name and password of the owner of the new database.

don’t confuse the the administrator (”owner”) of the Efficy database with the DBA role


This owner becomes the administrator of the Efficy database (user code: ADMIN)!


changing the administrator’s password

Tip: you can make use of the Alias, Customer and Guest Manager to maintain the administrator/database owner and his/her log-in.



Optionally enter the name and password for the dedicated database user who executes native SQL queries on the database.


Warning: any user with such a log-in and sufficient SQL experience can gain access to all database content. Given the security risk that implies, you should manage this option with care!


Tip: you can make use of the Alias, Customer and Guest Manager to maintain this log-in. Select the database alias and click the button Native SQL Login on the default tab Database Aliases.



Select what you want to copy – the full database (its structure and its data) or just the database structure.


© 2006-2020 Efficy All rights reserved