With the default installation of Pervasive Postgres, they are located in the directory 'C:\Program Files\Pervasive Postgres\bin'. You can use psql to log in the database server, perform administration tasks and execute SQL statements. Type 'psql --help' for usage.
pgAdmin III: it can be found in the program folder of Pervasive Postgres.
The following explanation applies to pgAdmin III.
Right click on 'Servers' in pgAdmin III and select 'Add server...'. Fill in the domain name or IP address of the machine on which the database server is installed. Give the server a description name. Fill in the password you set for the database super user in installation. Leave other options unchanged. Click OK. A server is added and a connection is established if the database server is running. Click the plus sign on the left of the newly added server to see its contents.
This step is optional. For security, it is advised that you add a non-privileged user that will be the owner of the new database to be created.
Right click on 'Users' and select 'New User'.
Right click on 'Databases' and select 'New Database'. Fill in the name of the database. Set the owner to the non-privileged user if it is created in the previous step. You may change the server properties so that the initial database and username are changed to the settings here.
You need to make some modifications to the DDL script generated by Rose.
Remove the non-null constraint for an attribute that is not required, such as computedFunction.
Extend the storage type for long data. For example, use TEXT type for protein sequence.
You may use serial types for setting up unique integer identifiers (primary keys), such as ids of proteins and protein sources.
Make sure that there is no conflict between the attribute names and database reserved keywords.
Additionally, the name used in provided script/code/model may not be exactly same as what you used in your own code. You should make changes accrodingly.
(Optional) Set up uniqueness constraints on attributes of candidate keys.
(Optional) Make the attribute names more readable.
Launch the query tool from the toolbar by pressing this button
.
Open the DDL script in the query tool and execute it. If the execution is successful, the tables and indexes will be created. You can find the tables at 'Servers->pervasive->Databases->rosetta->Schemas->public->Tables'.
Open this file in the query tool and execute it. The tables of proteins and protein sources will be populated. Perform queries on this database using the query tool.