PostgreSQL

  +
  Frees memory allocated by libpq, particularly link:libpq-exec.html#LIBPQ-PQESCAPEBYTEACONN[`+PQescapeByteaConn+`], link:libpq-exec.html#LIBPQ-PQESCAPEBYTEA[`+PQescapeBytea+`], link:libpq-exec.html#LIBPQ-PQUNESCAPEBYTEA[`+PQunescapeBytea+`], and `+PQnotifies+`. It is particularly important that this function, rather than `+free()+`, be used on Microsoft Windows. This is because allocating memory in a DLL and releasing it in the application works only if multithreaded/single-threaded, release/debug, and static/dynamic flags are the same for the DLL and the application. On non-Microsoft Windows platforms, this function is the same as the standard library function `+free()+`.
[.term]#`+PQconninfoFree+`::
  Frees the data structures allocated by link:libpq-connect.html#LIBPQ-PQCONNDEFAULTS[`+PQconndefaults+`] or link:libpq-connect.html#LIBPQ-PQCONNINFOPARSE[`+PQconninfoParse+`].
  +

  +
  A simple link:libpq-misc.html#LIBPQ-PQFREEMEM[`+PQfreemem+`] will not do for this, since the array contains references to subsidiary strings.
[.term]#`+PQencryptPasswordConn+`::
  Prepares the encrypted form of a PostgreSQL password.
  +

  +
  This function is intended to be used by client applications that wish to send commands like `+ALTER USER joe PASSWORD 'pwd'+`. It is good practice not to send the original cleartext password in such a command, because it might be exposed in command logs, activity displays, and so on. Instead, use this function to convert the password to encrypted form before it is sent.
  +
  The _`+passwd+`_ and _`+user+`_ arguments are the cleartext password, and the SQL name of the user it is for. _`+algorithm+`_ specifies the encryption algorithm to use to encrypt the password. Currently supported algorithms are `+md5+` and `+scram-sha-256+` (`+on+` and `+off+` are also accepted as aliases for `+md5+`, for compatibility with older server versions). Note that support for `+scram-sha-256+` was introduced in PostgreSQL version 10, and will not work correctly with older server versions. If _`+algorithm+`_ is `+NULL+`, this function will query the server for the current value of the link:runtime-config-connection.html#GUC-PASSWORD-ENCRYPTION[password_encryption] setting. That can block, and will fail if the current transaction is aborted, or if the connection is busy executing another query. If you wish to use the default algorithm for the server but want to avoid blocking, query `+password_encryption+` yourself before calling link:libpq-misc.html#LIBPQ-PQENCRYPTPASSWORDCONN[`+PQencryptPasswordConn+`], and pass that value as the _`+algorithm+`_.
  +
  The return value is a string allocated by `+malloc+`. The caller can assume the string doesn't contain any special characters that would require escaping. Use link:libpq-misc.html#LIBPQ-PQFREEMEM[`+PQfreemem+`] to free the result when done with it. On error, returns `+NULL+`, and a suitable message is stored in the connection object.
[.term]#`+PQencryptPassword+`::
  Prepares the md5-encrypted form of a PostgreSQL password.
  +

  +
  link:libpq-misc.html#LIBPQ-PQENCRYPTPASSWORD[`+PQencryptPassword+`] is an older, deprecated version of link:libpq-misc.html#LIBPQ-PQENCRYPTPASSWORDCONN[`+PQencryptPasswordConn+`]. The difference is that link:libpq-misc.html#LIBPQ-PQENCRYPTPASSWORD[`+PQencryptPassword+`] does not require a connection object, and `+md5+` is always used as the encryption algorithm.
[.term]#`+PQmakeEmptyPGresult+`::
  Constructs an empty `+PGresult+` object with the given status.
  +

  +
  This is libpq's internal function to allocate and initialize an empty `+PGresult+` object. This function returns `+NULL+` if memory could not be allocated. It is exported because some applications find it useful to generate result objects (particularly objects with error status) themselves. If _`+conn+`_ is not null and _`+status+`_ indicates an error, the current error message of the specified connection is copied into the `+PGresult+`. Also, if _`+conn+`_ is not null, any event procedures registered in the connection are copied into the `+PGresult+`. (They do not get `+PGEVT_RESULTCREATE+` calls, but see link:libpq-misc.html#LIBPQ-PQFIRERESULTCREATEEVENTS[`+PQfireResultCreateEvents+`].) Note that link:libpq-exec.html#LIBPQ-PQCLEAR[`+PQclear+`] should eventually be called on the object, just as with a `+PGresult+` returned by libpq itself.
[.term]#`+PQfireResultCreateEvents+`::
  Fires a `+PGEVT_RESULTCREATE+` event (see link:libpq-events.html[Section 34.14]) for each event procedure registered in the `+PGresult+` object. Returns non-zero for success, zero if any event procedure fails.
  +

  +
  The `+conn+` argument is passed through to event procedures but not used directly. It can be `+NULL+` if the event procedures won't use it.
  +
  Event procedures that have already received a `+PGEVT_RESULTCREATE+` or `+PGEVT_RESULTCOPY+` event for this object are not fired again.
  +
  The main reason that this function is separate from link:libpq-misc.html#LIBPQ-PQMAKEEMPTYPGRESULT[`+PQmakeEmptyPGresult+`] is that it is often appropriate to create a `+PGresult+` and fill it with data before invoking the event procedures.
[.term]#`+PQcopyResult+`::
  Makes a copy of a `+PGresult+` object. The copy is not linked to the source result in any way and link:libpq-exec.html#LIBPQ-PQCLEAR[`+PQclear+`] must be called when the copy is no longer needed. If the function fails, `+NULL+` is returned.
  +

  +
  This is not intended to make an exact copy. The returned result is always put into `+PGRES_TUPLES_OK+` status, and does not copy any error message in the source. (It does copy the command status string, however.) The _`+flags+`_ argument determines what else is copied. It is a bitwise OR of several flags. `+PG_COPYRES_ATTRS+` specifies copying the source result's attributes (column definitions). `+PG_COPYRES_TUPLES+` specifies copying the source result's tuples. (This implies copying the attributes, too.) `+PG_COPYRES_NOTICEHOOKS+` specifies copying the source result's notify hooks. `+PG_COPYRES_EVENTS+` specifies copying the source result's events. (But any instance data associated with the source is not copied.) The event procedures receive `+PGEVT_RESULTCOPY+` events.
[.term]#`+PQsetResultAttrs+`::
  Sets the attributes of a `+PGresult+` object.
  +

  +
  The provided _`+attDescs+`_ are copied into the result. If the _`+attDescs+`_ pointer is `+NULL+` or _`+numAttributes+`_ is less than one, the request is ignored and the function succeeds. If _`+res+`_ already contains attributes, the function will fail. If the function fails, the return value is zero. If the function succeeds, the return value is non-zero.
[.term]#`+PQsetvalue+`::
  Sets a tuple field value of a `+PGresult+` object.
  +

  +
  The function will automatically grow the result's internal tuples array as needed. However, the _`+tup_num+`_ argument must be less than or equal to link:libpq-exec.html#LIBPQ-PQNTUPLES[`+PQntuples+`], meaning this function can only grow the tuples array one tuple at a time. But any field of any existing tuple can be modified in any order. If a value at _`+field_num+`_ already exists, it will be overwritten. If _`+len+`_ is -1 or _`+value+`_ is `+NULL+`, the field value will be set to an SQL null value. The _`+value+`_ is copied into the result's private storage, thus is no longer needed after the function returns. If the function fails, the return value is zero. If the function succeeds, the return value is non-zero.
[.term]#`+PQresultAlloc+`::
  Allocate subsidiary storage for a `+PGresult+` object.
  +

  +
  Any memory allocated with this function will be freed when _`+res+`_ is cleared. If the function fails, the return value is `+NULL+`. The result is guaranteed to be adequately aligned for any type of data, just as for `+malloc+`.
[.term]#`+PQresultMemorySize+`::
  Retrieves the number of bytes allocated for a `+PGresult+` object.
  +

  +
  This value is the sum of all `+malloc+` requests associated with the `+PGresult+` object, that is, all the space that will be freed by link:libpq-exec.html#LIBPQ-PQCLEAR[`+PQclear+`]. This information can be useful for managing memory consumption.
[.term]#`+PQlibVersion+`::
  Return the version of libpq that is being used.
  +

+
The result of this function can be used to determine, at run time, whether specific functionality is available in the currently loaded version of libpq. The function can be used, for example, to determine which connection options are available in link:libpq-connect.html#LIBPQ-PQCONNECTDB[`+PQconnectdb+`].
+
The result is formed by multiplying the library's major version number by 10000 and adding the minor version number. For example, version 10.1 will be returned as 100001, and version 11.0 will be returned as 110000.
+
Prior to major version 10, PostgreSQL used three-part version numbers in which the first two parts together represented the major version. For those versions, link:libpq-misc.html#LIBPQ-PQLIBVERSION[`+PQlibVersion+`] uses two digits for each part; for example version 9.1.5 will be returned as 90105, and version 9.2.0 will be returned as 90200.
+
Therefore, for purposes of determining feature compatibility, applications should divide the result of link:libpq-misc.html#LIBPQ-PQLIBVERSION[`+PQlibVersion+`] by 100 not 10000 to determine a logical major version number. In all release series, only the last two digits differ between minor releases (bug-fix releases).
+
[NOTE]
====
==== Note

This function appeared in PostgreSQL version 9.1, so it cannot be used to detect required functionality in earlier versions, since calling it will create a link dependency on version 9.1 or later.
====