File Manager

Hackfut Security File Manager

Current Path: /opt/td-agent/embedded/share/man/man3

opt / td-agent / embedded / share / man / man3 /

📁 ..
📄 SPI_connect.3(2.18 KB)
📄 SPI_copytuple.3(1.76 KB)
📄 SPI_cursor_close.3(1.71 KB)
📄 SPI_cursor_fetch.3(2.05 KB)
📄 SPI_cursor_find.3(1.71 KB)
📄 SPI_cursor_move.3(1.92 KB)
📄 SPI_cursor_open.3(3.49 KB)
📄 SPI_cursor_open_with_args.3(3.77 KB)
📄 SPI_cursor_open_with_paramlist.3(2.78 KB)
📄 SPI_exec.3(1.72 KB)
📄 SPI_execp.3(2.65 KB)
📄 SPI_execute.3(7.86 KB)
📄 SPI_execute_plan.3(3.14 KB)
📄 SPI_execute_plan_with_paramlist.3(2.63 KB)
📄 SPI_execute_with_args.3(3.87 KB)
📄 SPI_finish.3(2.05 KB)
📄 SPI_fname.3(1.86 KB)
📄 SPI_fnumber.3(2.1 KB)
📄 SPI_freeplan.3(1.7 KB)
📄 SPI_freetuple.3(1.68 KB)
📄 SPI_freetuptable.3(2.37 KB)
📄 SPI_getargcount.3(1.83 KB)
📄 SPI_getargtypeid.3(2.09 KB)
📄 SPI_getbinval.3(2.24 KB)
📄 SPI_getnspname.3(1.78 KB)
📄 SPI_getrelname.3(1.68 KB)
📄 SPI_gettype.3(1.87 KB)
📄 SPI_gettypeid.3(1.79 KB)
📄 SPI_getvalue.3(2.11 KB)
📄 SPI_is_cursor_plan.3(2.33 KB)
📄 SPI_keepplan.3(2.02 KB)
📄 SPI_modifytuple.3(3.35 KB)
📄 SPI_palloc.3(1.6 KB)
📄 SPI_pfree.3(1.68 KB)
📄 SPI_pop.3(1.45 KB)
📄 SPI_prepare.3(5.21 KB)
📄 SPI_prepare_cursor.3(2.53 KB)
📄 SPI_prepare_params.3(2.34 KB)
📄 SPI_push.3(2.2 KB)
📄 SPI_repalloc.3(1.91 KB)
📄 SPI_returntuple.3(2.12 KB)
📄 SPI_saveplan.3(2.41 KB)
📄 SPI_scroll_cursor_fetch.3(2.36 KB)
📄 SPI_scroll_cursor_move.3(2.41 KB)
📄 dblink.3(6.49 KB)
📄 dblink_build_sql_delete.3(3.26 KB)
📄 dblink_build_sql_insert.3(3.85 KB)
📄 dblink_build_sql_update.3(4.1 KB)
📄 dblink_cancel_query.3(2.1 KB)
📄 dblink_close.3(2.7 KB)
📄 dblink_connect.3(5.66 KB)
📄 dblink_connect_u.3(2.73 KB)
📄 dblink_disconnect.3(2.09 KB)
📄 dblink_error_message.3(1.82 KB)
📄 dblink_exec.3(3.73 KB)
📄 dblink_fetch.3(4.15 KB)
📄 dblink_get_connections.3(1.7 KB)
📄 dblink_get_notify.3(2.48 KB)
📄 dblink_get_pkey.3(2.63 KB)
📄 dblink_get_result.3(4.86 KB)
📄 dblink_is_busy.3(1.82 KB)
📄 dblink_open.3(3.21 KB)
📄 dblink_send_query.3(2.32 KB)
📄 editline.3(20.41 KB)
📄 el_deletestr.3(20.41 KB)
📄 el_end.3(20.41 KB)
📄 el_get.3(20.41 KB)
📄 el_getc.3(20.41 KB)
📄 el_gets.3(20.41 KB)
📄 el_history.3(20.41 KB)
📄 el_history_end.3(20.41 KB)
📄 el_history_init.3(20.41 KB)
📄 el_init.3(20.41 KB)
📄 el_insertstr.3(20.41 KB)
📄 el_line.3(20.41 KB)
📄 el_parse.3(20.41 KB)
📄 el_push.3(20.41 KB)
📄 el_reset.3(20.41 KB)
📄 el_resize.3(20.41 KB)
📄 el_set.3(20.41 KB)
📄 el_source.3(20.41 KB)
📄 el_tok_end.3(20.41 KB)
📄 el_tok_init.3(20.41 KB)
📄 el_tok_line.3(20.41 KB)
📄 el_tok_reset.3(20.41 KB)
📄 el_tok_str.3(20.41 KB)
📄 ffi.3(850 B)
📄 ffi_call.3(2.28 KB)
📄 ffi_prep_cif.3(1.13 KB)
📄 ffi_prep_cif_var.3(1.29 KB)
📄 jemalloc.3(71.09 KB)
📄 libexslt.3(6.37 KB)
📄 libxml.3(1.59 KB)
📄 libxslt.3(816 B)
📄 zlib.3(4.37 KB)

Editing: dblink.3

'\" t
.\"     Title: dblink
.\"    Author: The PostgreSQL Global Development Group
.\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
.\"      Date: 2018
.\"    Manual: PostgreSQL 9.6.9 Documentation
.\"    Source: PostgreSQL 9.6.9
.\"  Language: English
.\"
.TH "DBLINK" "3" "2018" "PostgreSQL 9.6.9" "PostgreSQL 9.6.9 Documentation"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
dblink \- executes a query in a remote database
.SH "SYNOPSIS"
.sp
.nf
dblink(text connname, text sql [, bool fail_on_error]) returns setof record
dblink(text connstr, text sql [, bool fail_on_error]) returns setof record
dblink(text sql [, bool fail_on_error]) returns setof record
.fi
.SH "DESCRIPTION"
.PP
\fBdblink\fR
executes a query (usually a
\fBSELECT\fR, but it can be any SQL statement that returns rows) in a remote database\&.
.PP
When two
text
arguments are given, the first one is first looked up as a persistent connection\*(Aqs name; if found, the command is executed on that connection\&. If not found, the first argument is treated as a connection info string as for
\fBdblink_connect\fR, and the indicated connection is made just for the duration of this command\&.
.SH "ARGUMENTS"
.PP
\fIconnname\fR
.RS 4
Name of the connection to use; omit this parameter to use the unnamed connection\&.
.RE
.PP
\fIconnstr\fR
.RS 4
A connection info string, as previously described for
\fBdblink_connect\fR\&.
.RE
.PP
\fIsql\fR
.RS 4
The SQL query that you wish to execute in the remote database, for example
select * from foo\&.
.RE
.PP
\fIfail_on_error\fR
.RS 4
If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown locally\&. If false, the remote error is locally reported as a NOTICE, and the function returns no rows\&.
.RE
.SH "RETURN VALUE"
.PP
The function returns the row(s) produced by the query\&. Since
\fBdblink\fR
can be used with any query, it is declared to return
record, rather than specifying any particular set of columns\&. This means that you must specify the expected set of columns in the calling query \(em otherwise
PostgreSQL
would not know what to expect\&. Here is an example:
.sp
.if n \{\
.RS 4
.\}
.nf
SELECT *
    FROM dblink(\*(Aqdbname=mydb options=\-csearch_path=\*(Aq,
                \*(Aqselect proname, prosrc from pg_proc\*(Aq)
      AS t1(proname name, prosrc text)
    WHERE proname LIKE \*(Aqbytea%\*(Aq;
.fi
.if n \{\
.RE
.\}
.sp
The
\(lqalias\(rq
part of the
FROM
clause must specify the column names and types that the function will return\&. (Specifying column names in an alias is actually standard SQL syntax, but specifying column types is a
PostgreSQL
extension\&.) This allows the system to understand what
*
should expand to, and what
proname
in the
WHERE
clause refers to, in advance of trying to execute the function\&. At run time, an error will be thrown if the actual query result from the remote database does not have the same number of columns shown in the
FROM
clause\&. The column names need not match, however, and
\fBdblink\fR
does not insist on exact type matches either\&. It will succeed so long as the returned data strings are valid input for the column type declared in the
FROM
clause\&.
.SH "NOTES"
.PP
A convenient way to use
\fBdblink\fR
with predetermined queries is to create a view\&. This allows the column type information to be buried in the view, instead of having to spell it out in every query\&. For example,
.sp
.if n \{\
.RS 4
.\}
.nf
CREATE VIEW myremote_pg_proc AS
  SELECT *
    FROM dblink(\*(Aqdbname=postgres options=\-csearch_path=\*(Aq,
                \*(Aqselect proname, prosrc from pg_proc\*(Aq)
    AS t1(proname name, prosrc text);

SELECT * FROM myremote_pg_proc WHERE proname LIKE \*(Aqbytea%\*(Aq;
.fi
.if n \{\
.RE
.\}
.SH "EXAMPLES"
.sp
.if n \{\
.RS 4
.\}
.nf
SELECT * FROM dblink(\*(Aqdbname=postgres options=\-csearch_path=\*(Aq,
                     \*(Aqselect proname, prosrc from pg_proc\*(Aq)
  AS t1(proname name, prosrc text) WHERE proname LIKE \*(Aqbytea%\*(Aq;
  proname   |   prosrc
\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-
 byteacat   | byteacat
 byteaeq    | byteaeq
 bytealt    | bytealt
 byteale    | byteale
 byteagt    | byteagt
 byteage    | byteage
 byteane    | byteane
 byteacmp   | byteacmp
 bytealike  | bytealike
 byteanlike | byteanlike
 byteain    | byteain
 byteaout   | byteaout
(12 rows)

SELECT dblink_connect(\*(Aqdbname=postgres options=\-csearch_path=\*(Aq);
 dblink_connect
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-
 OK
(1 row)

SELECT dblink_connect(\*(Aqmyconn\*(Aq, \*(Aqdbname=regression options=\-csearch_path=\*(Aq);
 dblink_connect
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-
 OK
(1 row)

SELECT * FROM dblink(\*(Aqmyconn\*(Aq, \*(Aqselect proname, prosrc from pg_proc\*(Aq)
  AS t1(proname name, prosrc text) WHERE proname LIKE \*(Aqbytea%\*(Aq;
  proname   |   prosrc
\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-
 bytearecv  | bytearecv
 byteasend  | byteasend
 byteale    | byteale
 byteagt    | byteagt
 byteage    | byteage
 byteane    | byteane
 byteacmp   | byteacmp
 bytealike  | bytealike
 byteanlike | byteanlike
 byteacat   | byteacat
 byteaeq    | byteaeq
 bytealt    | bytealt
 byteain    | byteain
 byteaout   | byteaout
(14 rows)
.fi
.if n \{\
.RE
.\}

Hackfut Security File Manager

Editing: dblink.3

Upload File

Create Folder