db_blob_get (public)

 db_blob_get [ -dbn dbn ] statement_name sql [ args... ]

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

PostgreSQL only.

-dbn (optional)
The database name to use. If empty_string, uses the default database.
Source code:
    ad_arg_parser { bind } $args
    set proc_name {db_blob_get}
    set driverkey [db_driverkey $dbn]

    switch $driverkey {

        postgresql {
            set full_statement_name [db_qd_get_fullname $statement_name]
            db_with_handle -dbn $dbn db {
                set data [db_exec_lob blob_get $db $full_statement_name $sql]
            return $data

        oracle {
            set pre_sql $sql
            set full_statement_name [db_qd_get_fullname $statement_name]
            set sql [db_qd_replace_sql $full_statement_name $pre_sql]

            # insert Tcl variable values (borrowed from Dan W - olah)
            if {$sql ne $pre_sql } {
                set sql [uplevel 2 [list subst -nobackslashes $sql]]

            set data [db_string dummy_statement_name $sql]
            return $data

        nsodbc -
        default {
            error "$proc_name is not supported for this database."
XQL Not present:
Generic, PostgreSQL, Oracle
[ hide source ] | [ make this the default ]
Show another procedure: