Creating and Dropping Tables

Use the standard PostgreSQL commands to create and drop tables in Hyperstage, the same as you would with a PostgreSQL table. For detailed syntax information, see the PostgreSQL 9.2 Documentation.

Important: Do not manually copy a data table from one database to another by copying the database files. Internal table numbering errors and Knowledge Grid inconsistencies may occur. To copy a table from one database to another, export from the source database and then import into the target database (see Importing and Exporting Data in Hyperstage) or back up the entire database directory (see Hyperstage Backup and Recovery). You can rename the entire database by renaming the folder. However, you should not copy a database folder from one active instance to another, or within the same active instance.

To create a table, enter the following command:

psql> create table <table_name> (<column(s)>) with (ENGINE=BRIGHTHOUSE);


To drop a table, enter the following command:

psql> drop table table_name;

For information on supported and unsupported options when creating columns, see About Column Options.