GPContainerPGSql() builds on the properties and features of GPContainer(), to provide automatic creation of SQL statements and firing them at the PostgreSQL server.

SQL statements supported are:

• INSERT - create a new record
• UPDATE - change an existing record

Methods also exist to fetch:

• List of tables in current database
• Field descriptions for a table/join
• List of indexes for a table (and the code that creates them)
• List of Views in the current database

You can also fire arbitrary queries at the server and cast data from Xbase++ types to PostgreSQL data types.