PG_RETURN_TEXT_P(cstring_to_text(sql));

}

PG_FUNCTION_INFO_V1(dblink_current_query);

dblink_current_query(PG_FUNCTION_ARGS)

{

if (debug_query_string)

PG_RETURN_TEXT_P(cstring_to_text(debug_query_string));

PG_RETURN_NULL();

}

externDatumdblink_build_sql_insert(PG_FUNCTION_ARGS);

externDatumdblink_build_sql_delete(PG_FUNCTION_ARGS);

externDatumdblink_build_sql_update(PG_FUNCTION_ARGS);

externDatumdblink_current_query(PG_FUNCTION_ARGS);

/* $PostgreSQL: pgsql/contrib/dblink/dblink.sql.in,v 1.14 2007/11/13 04:24:27 momjian Exp $ */

/* $PostgreSQL: pgsql/contrib/dblink/dblink.sql.in,v 1.15 2008/04/04 16:57:21 momjian Exp $ */

-- Adjust this setting to control where the objects get created.

SET search_path = public;

AS 'MODULE_PATHNAME','dblink_build_sql_update'

LANGUAGE C STRICT;

CREATE OR REPLACE FUNCTION dblink_current_query ()

RETURNS text

AS 'MODULE_PATHNAME','dblink_current_query'

LANGUAGE C;

CREATE OR REPLACE FUNCTION dblink_send_query(text, text)

RETURNS int4

AS 'MODULE_PATHNAME', 'dblink_send_query'

INSERT INTO foo VALUES (8,'i','{"a8","b8","c8"}');

INSERT INTO foo VALUES (9,'j','{"a9","b9","c9"}');

-- misc utilities

-- show the currently executing query

SELECT 'hello' AS hello, dblink_current_query() AS query;

hello | query

-------+-----------------------------------------------------------

hello | SELECT 'hello' AS hello, dblink_current_query() AS query;

(1 row)

-- list the primary key fields

SELECT *

FROM dblink_get_pkey('foo');

SELECT'hello'AS hello, dblink_current_query()AS query;

FROM dblink_get_pkey('foo');

SET search_path= public;

DROPFUNCTION dblink_current_query ();

DROPFUNCTION dblink_build_sql_update (text, int2vector, int4, _text, _text);

DROPFUNCTION dblink_build_sql_delete (text, int2vector, int4, _text);

<!-- $PostgreSQL: pgsql/doc/src/sgml/dblink.sgml,v 1.3 2007/12/06 04:12:09 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/dblink.sgml,v 1.4 2008/04/04 16:57:21 momjian Exp $ -->

<sect1 id="dblink">

<title>dblink</title>

</refsect1>

</refentry>

<refentry id="CONTRIB-DBLINK-CURRENT-QUERY">

<refnamediv>

<refname>dblink_current_query</refname>

<refpurpose>returns the current query string</refpurpose>

</refnamediv>

<refsynopsisdiv>

<synopsis>

dblink_current_query() returns text

</synopsis>

</refsynopsisdiv>

<refsect1>

<title>Description</title>

<para>

Returns the currently executing interactive command string of the

local database session, or NULL if it can't be determined. Note

that this function is not really related to <filename>dblink</>'s

other functionality. It is provided since it is sometimes useful

in generating queries to be forwarded to remote databases.

</para>

</refsect1>

<refsect1>

<title>Return Value</title>

<para>Returns a copy of the currently executing query string.</para>

</refsect1>

<refsect1>

<title>Example</title>

<programlisting>

test=# select dblink_current_query();

dblink_current_query

--------------------------------

select dblink_current_query();

(1 row)

</programlisting>

</refsect1>

</refentry>

<refentry id="CONTRIB-DBLINK-GET-PKEY">

<refnamediv>

<refname>dblink_get_pkey</refname>

<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.425 2008/03/23 00:24:19 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.426 2008/04/04 16:57:21 momjian Exp $ -->

<chapter id="functions">

<title>Functions and Operators</title>

<entry>user name of current execution context</entry>

</row>

<row>

<entry><literal><function>current_query</function></literal></entry>

<entry><type>text</type></entry>

<entry>text of the currently executing query (might contain more than one statement)</entry>

</row>

<row>

<entry><literal><function>inet_client_addr</function>()</literal></entry>

<entry><type>inet</type></entry>

#defineatooid(x) ((Oid) strtoul((x), NULL, 10))

}

current_query(PG_FUNCTION_ARGS)

{

if (debug_query_string)

PG_RETURN_TEXT_P(cstring_to_text(debug_query_string));

PG_RETURN_NULL();

}

DATA(insertOID=861 (current_databasePGNSPPGUID1210fftfi019""_null__null__null_current_database-_null__null_ ));

DESCR("returns the current database");

DATA(insertOID=817 (current_queryPGNSPPGUID1210ffffv025""_null__null__null_current_query-_null__null_ ));

DESCR("returns the currently executing query");

DATA(insertOID=862 (int4_mul_cashPGNSPPGUID1210fftfi2790"23 790"_null__null__null_int4_mul_cash-_null__null_ ));

DESCR("multiply");