db_get_pgbin (public)

 db_get_pgbin [ -dbn dbn ]

Defined in packages/acs-tcl/tcl/01-database-procs.tcl

PostgreSQL only.

Switches:

-dbn (optional)

The database name to use. If empty_string, uses the default database.

Returns:

the pgbin parameter from the driver section of the first database pool.

Testcases:

acs_tcl_exec_required_dependencies, acs_tcl_exec_optional_dependencies

Source code:

    #
    # First, we try to get the postgres folder from the conf.
    #
    set pool [lindex [db_available_pools $dbn] 0]
    set driver [ns_config "ns/db/pool/$pool" Driver]
    set pgbin [ns_config "ns/db/driver/$driver" pgbin]

    if {$pgbin eq ""} {
        #
        # When the pgbin conf is missing, we guess the folder from the
        # psql location.
        #
        set pgbin [file dirname [util::which psql]]
    }

    return $pgbin

XQL Not present:

Generic, PostgreSQL, Oracle