---

Class ::acs::db::postgresql

::acs::db::postgresql create ...

Support class for backend based on PostgreSQL, i.e., the PostgreSQL dialect of SQL). This class can be used with the nsdb and the nsdbi drivers of NaviServer.

Defined in packages/acs-tcl/tcl/acs-db-12-procs.tcl

Class Relations

• class: ::nx::Class
• superclass: ::acs::db::SQL
• subclass: ::acs::db::nsdb-postgresql, ::acs::db::nsdbi-postgresql

Methods (to be applied on instances)

• get_all_package_functions (scripted, public)

   <instance of acs::db::postgresql> get_all_package_functions \
      [ -dbn dbn ]

  PostgreSQL version of obtaining information about the procedures and functions stored in the DB. For PostgreSQL, we keep this in the table "function_args". The information from "acs_function_args" defines, for which functions we want to create an interface. The information is completed with the definitions from the system catalog of PostgreSQL. The resulting list contains entries of the form: sqlpackage object {argument_names ... types ... defaulted ... defaults result_type ....} Currently, "defaults" are only available for PostgreSQL

  Switches:

  -dbn (optional)

  Testcases:

  No testcase defined.

• map_function_name (scripted, public)

   <instance of acs::db::postgresql> map_function_name sql

  Replace calls to function names in provided SQL (dummy function for PostgreSQL)

  Parameters:

  sql (required)

  Testcases:

  No testcase defined.

---