The SQL Command Center combined with the SQL Column Lookup will enable the user to inquire almost all the data contained in the Perfect Fit database.
It is an extremely flexible report writer.
It is for reporting only and does not enable inserting or editing data.
SQL is a common database language so searching on the internet will help you write the code.
Include the phrase PostgreSQL to get the version that PF uses.
MenusSQL > SQL Command Center
The example in this screen shot shows the basic code to retrieve a list of specific customer fields with a search on a date and a sort on the customer name.
MenusSQL > SQL Column Lookup
Column Lookup window help you find exact fields names and their descriptions.
This tool takes the place of the Data File Browser in PF7.
Inserted by AG on 09-07-2026