Using PSQL Documentation
All PSQL documentation assumes you are familiar with the basics of using a computer, such as clicking and dragging, opening and saving files. If you need assistance with these tasks, please consult the documentation that came with your computer and/or operating system.
The viewer for the user documentation is integrated into PSQL Control Center (PCC). Access the documentation through the PCC interface on the Welcome view, in the Help menu, by pressing F1 (Windows) or Shift F1 (Linux).
The following is a summary of the most commonly used books in the documentation library. The library contains other books, all of which can be accessed through the PCC interface as explained above.
Getting Started
Getting Started with PSQL helps you get PSQL running with installation, setup, and troubleshooting information. Getting Started With PSQL covers the following topics:
•
Preparing to install PSQL v12
•
Installing PSQL v12
•
Upgrading from previous versions of PSQL or Btrieve
•
Configuring PSQL v12
•
Troubleshooting your PSQL v12 installation
What’s New
What’s New in PSQL provides an overview of the new features and changed behavior for the current release of PSQL relative to the most recent previous release. This book provides summary information on new features and directs you to the locations in the documentation where the new features are fully discussed.
User’s Guide
PSQL User's Guide introduces PSQL and describes common user tasks. The guide discusses the database engine, PSQL utilities and other key components; the differences between Server and Workgroup engines; and the differences between ODBC and Btrieve access. PSQL User's Guide provides you with the basics to work with PSQL successfully.
Advanced Operations Guide
Advanced Operations Guide provides detailed information at the administrative level, including the steps to perform common procedures and several new ones. Topics include:
•
checking database consistency
•
performing periodic backups
•
configuring network protocols and understanding network topologies
•
working with database security
•
basic configuration guidelines
•
configuration options reference
•
moving, renaming, compacting and rebuilding files
SQL Engine Reference
SQL Engine Reference gives database programmers a complete reference guide to the SQL relational database language. It also covers SQL engine parameters and limitations.
Status Codes and Messages
Status Codes and Messages documents all possible status codes and numbered messages that can be received when using PSQL.
The Status Codes Quick Reference is also included with your complete documentation set.
Additional Information
You can download the product documentation, white papers, technical papers, and use the online library at the Actian PSQL website.