Page History

...

1. In the Servoy Developer Solution Explorer tab, expand the Database Servers node (under Resources) and right click on any PostgreSQL database (all the example databases provided by Servoy are PostgreSQL) to show the popup menu.
2. Select Create PostGreSQL Database.
3. Enter a name for the database in the dialog window.
4. A dialog will appear as the database is being created.
5. Another dialog will alert you that the creation is finished. Click OK.

Connecting to an Existing Database

...

1. Right click on the database name in the Database Servers node and select Create Table OR With the database name selected, click on the create table button in toolbar of the list view in Solution Explorer.
2. A dialog will ask for the name for a new table. Enter the name and click OK.
3. The table editor view will appear allowing new columns to be entered.

   Note
   title NOTE
   When a new table is created, Servoy will add a column in the table editor for the primary key. All tables used in Servoy must have a primary key or a row identifier.

...

1. Open the table editor by selecting the database server in the Solution Explorer and doing one of the following in the list view:
   1. Double clicking on the table name.
   2. Right clicking on the table name and selecting Edit table/view.
   3. Select the table and click on the edit table button in the list view toolbar.
2. The table editor will appear allowing editing of the columns for the table.
3. To add a column, click on the Add button. Change the name from "type here" to your desired name, the column type, and size (if applicable). Be sure to save when finished.
4. To remove a column, click on the Remove button.

Quick Start Video