diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 37 |
1 files changed, 36 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 3ead1346796..82081e514fa 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.204 2004/05/26 15:25:57 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.205 2004/05/26 18:35:31 momjian Exp $ PostgreSQL documentation --> @@ -6593,6 +6593,30 @@ SELECT NULLIF(value, '(none)') ... </row> <row> + <entry><function>inet_client_addr</function></entry> + <entry><type>inet</type></entry> + <entry>address of the remote connection</entry> + </row> + + <row> + <entry><function>inet_client_port</function></entry> + <entry><type>int4</type></entry> + <entry>port of the remote connection</entry> + </row> + + <row> + <entry><function>inet_server_addr</function></entry> + <entry><type>inet</type></entry> + <entry>address of the local connection</entry> + </row> + + <row> + <entry><function>inet_server_port</function></entry> + <entry><type>int4</type></entry> + <entry>port of the local connection</entry> + </row> + + <row> <entry><function>session_user</function></entry> <entry><type>name</type></entry> <entry>session user name</entry> @@ -6648,6 +6672,17 @@ SELECT NULLIF(value, '(none)') ... </note> <para> + <function>inet_client_addr</function> and + <function>inet_server_addr</function> return the IPv4 or IPv6 (if + configured) address of the remote or local host connecting to the + database, respectively. <function>inet_client_port</function> + and <function>inet_server_port</function> return the port number + of the remote or local host connecting to the database, + respectively. If the connection is not a network connection, + these functions will return <literal>NULL</literal>. + </para> + + <para> <function>current_schema</function> returns the name of the schema that is at the front of the search path (or a null value if the search path is empty). This is the schema that will be used for any tables or |