'\" t
.\"     Title: pgpool_adm_pcp_node_count
.\"    Author: The Pgpool Global Development Group
.\" Generator: DocBook XSL Stylesheets vsnapshot <http://docbook.sf.net/>
.\"      Date: 2023
.\"    Manual: pgpool-II 4.3.7 Documentation
.\"    Source: pgpool-II 4.3.7
.\"  Language: English
.\"
.TH "PGPOOL_ADM_PCP_NODE_COUNT" "3" "2023" "pgpool-II 4.3.7" "pgpool-II 4.3.7 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"
pgpool_adm_pcp_node_count \- a function to retrieves number of backend nodes\&.
.SH "SYNOPSIS"
.HP \w'pcp_node_count\ returns\ integer('u
.BI "pcp_node_count returns integer(text\ " "host" ", integer\ " "port" ", text\ " "username" ", text\ " "password" ");"
.HP \w'pcp_node_count\ returns\ integer('u
.BI "pcp_node_count returns integer(text\ " "pcp_server" ");"
.SH "DESCRIPTION"
.PP
\fBpcp_node_count\fR
retrieves number of DB nodes\&.
.SH "ARGUMENTS"
.PP
.PP
\fIpcp_server\fR
.RS 4
The foreign server name for pcp server\&.
.RE
.PP
\fBOther arguments \fR
.RS 4
See
\fBpcp_common_options\fR(1)\&.
.RE
.SH "EXAMPLE"
.PP
Here is an example output:
.sp
.if n \{\
.RS 4
.\}
.nf
    test=# SELECT * FROM pcp_node_count(host => \*(Aqlocalhost\*(Aq, port => 11001, username => \*(Aqt\-ishii\*(Aq, password => \*(Aqt\-ishii\*(Aq);
    node_count
    \-\-\-\-\-\-\-\-\-\-\-\-
    2
    (1 row)
   
.fi
.if n \{\
.RE
.\}
.sp