Search PostgreSQL documentation

psql --username=usernameCommand-line ToolsPG18-U username--username=username Connect to the database as the user username instead of the default. (You must have permission to do so, of course.)psql › Options psql --variable=assignmentCommand-line ToolsPG18-v assignment--set=assignment--variable=assignment Perform a variable assignment, like the \set meta-command. Note that you must separate name and value, if any, by an equal sign on the comm…psql › Options psql --versionCommand-line ToolsPG18-V--version Print the psql version and exit.psql › Options reindexdbCommand-line ToolsPG18reindexdb reindexdb — reindex a PostgreSQL database Synopsis reindexdb [connection-option...] [option...] [ -S | --schema schema ] ... [ -t | --table table ] ... [ -i | --index index ] ... […reindexdb reindexdb --allCommand-line ToolsPG18-a--all Reindex all databases.reindexdb › Options reindexdb --concurrentlyCommand-line ToolsPG18--concurrently Use the CONCURRENTLY option. See REINDEX, where all the caveats of this option are explained in detail.reindexdb › Options reindexdb --echoCommand-line ToolsPG18-e--echo Echo the commands that reindexdb generates and sends to the server.reindexdb › Options reindexdb --helpCommand-line ToolsPG18-?--help Show help about reindexdb command line arguments, and exit.reindexdb › Options reindexdb --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.reindexdb › Options reindexdb --index=indexCommand-line ToolsPG18-i index--index=index Recreate index only. Multiple indexes can be recreated by writing multiple -i switches.reindexdb › Options reindexdb --jobs=njobsCommand-line ToolsPG18-j njobs--jobs=njobs Execute the reindex commands in parallel by running njobs commands simultaneously. This option may reduce the processing time but it also increases the load on the datab…reindexdb › Options reindexdb --maintenance-db=dbnameCommand-line ToolsPG18--maintenance-db=dbname When the -a/--all is used, connect to this database to gather the list of databases to reindex. If not specified, the postgres database will be used, or if that does …reindexdb › Options reindexdb --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…reindexdb › Options reindexdb --passwordCommand-line ToolsPG18-W--password Force reindexdb to prompt for a password before connecting to a database. This option is never essential, since reindexdb will automatically prompt for a password if the server …reindexdb › Options reindexdb --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.reindexdb › Options reindexdb --quietCommand-line ToolsPG18-q--quiet Do not display progress messages.reindexdb › Options reindexdb --schema=schemaCommand-line ToolsPG18-S schema--schema=schema Reindex schema only. Multiple schemas can be reindexed by writing multiple -S switches.reindexdb › Options reindexdb --systemCommand-line ToolsPG18-s--system Reindex database's system catalogs only.reindexdb › Options reindexdb --table=tableCommand-line ToolsPG18-t table--table=table Reindex table only. Multiple tables can be reindexed by writing multiple -t switches.reindexdb › Options reindexdb --tablespace=tablespaceCommand-line ToolsPG18--tablespace=tablespace Specifies the tablespace where indexes are rebuilt. (This name is processed as a double-quoted identifier.)reindexdb › Options reindexdb --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.reindexdb › Options reindexdb --verboseCommand-line ToolsPG18-v--verbose Print detailed information during processing.reindexdb › Options reindexdb --versionCommand-line ToolsPG18-V--version Print the reindexdb version and exit.reindexdb › Options reindexdb [--dbname=]dbnameCommand-line ToolsPG18[-d] dbname[--dbname=]dbname Specifies the name of the database to be reindexed, when -a/--all is not used. If this is not specified, the database name is read from the environment variable …reindexdb › Options replicationCommand-line ToolsPG18replication This option determines whether the connection should use the replication protocol instead of the normal protocol. This is what PostgreSQL replication connections as well as tools…Database Connection Control Functions › Parameter Key Words require_authCommand-line ToolsPG18require_auth Specifies the authentication method that the client requires from the server. If the server does not use the required method to authenticate the client, or if the authentication…Database Connection Control Functions › Parameter Key Words requirepeerCommand-line ToolsPG18requirepeer This parameter specifies the operating-system user name of the server, for example requirepeer=postgres. When making a Unix-domain socket connection, if this parameter is set, th…Database Connection Control Functions › Parameter Key Words requiresslCommand-line ToolsPG18requiressl This option is deprecated in favor of the sslmode setting. If set to 1, an SSL connection to the server is required (this is equivalent to sslmode require). libpq will then refuse…Database Connection Control Functions › Parameter Key Words scram_client_keyCommand-line ToolsPG18scram_client_key The base64-encoded SCRAM client key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.38.1.10 for o…Database Connection Control Functions › Parameter Key Words scram_server_keyCommand-line ToolsPG18scram_server_key The base64-encoded SCRAM server key. This can be used by foreign-data wrappers or similar middleware to enable pass-through SCRAM authentication. See Section F.38.1.10 for o…Database Connection Control Functions › Parameter Key Words serviceCommand-line ToolsPG18service Service name to use for additional parameters. It specifies a service name in pg_service.conf that holds additional connection parameters. This allows applications to specify only a …Database Connection Control Functions › Parameter Key Words ssl_max_protocol_versionCommand-line ToolsPG18ssl_max_protocol_version This parameter specifies the maximum SSL/TLS protocol version to allow for the connection. Valid values are TLSv1, TLSv1.1, TLSv1.2 and TLSv1.3. The supported protoc…Database Connection Control Functions › Parameter Key Words ssl_min_protocol_versionCommand-line ToolsPG18ssl_min_protocol_version This parameter specifies the minimum SSL/TLS protocol version to allow for the connection. Valid values are TLSv1, TLSv1.1, TLSv1.2 and TLSv1.3. The supported protoc…Database Connection Control Functions › Parameter Key Words sslcertCommand-line ToolsPG18sslcert This parameter specifies the file name of the client SSL certificate, replacing the default ~/.postgresql/postgresql.crt. This parameter is ignored if an SSL connection is not made.Database Connection Control Functions › Parameter Key Words sslcertmodeCommand-line ToolsPG18sslcertmode This option determines whether a client certificate may be sent to the server, and whether the server is required to request one. There are three modes: disable A client certific…Database Connection Control Functions › Parameter Key Words sslcompressionCommand-line ToolsPG18sslcompression If set to 1, data sent over SSL connections will be compressed. If set to 0, compression will be disabled. The default is 0. This parameter is ignored if a connection without …Database Connection Control Functions › Parameter Key Words sslcrlCommand-line ToolsPG18sslcrl This parameter specifies the file name of the SSL server certificate revocation list (CRL). Certificates listed in this file, if it exists, will be rejected while attempting to authen…Database Connection Control Functions › Parameter Key Words sslcrldirCommand-line ToolsPG18sslcrldir This parameter specifies the directory name of the SSL server certificate revocation list (CRL). Certificates listed in the files in this directory, if it exists, will be rejected …Database Connection Control Functions › Parameter Key Words sslkeyCommand-line ToolsPG18sslkey This parameter specifies the location for the secret key used for the client certificate. It can either specify a file name that will be used instead of the default ~/.postgresql/post…Database Connection Control Functions › Parameter Key Words sslkeylogfileCommand-line ToolsPG18sslkeylogfile This parameter specifies the location where libpq will log keys used in this SSL context. This is useful for debugging PostgreSQL protocol interactions or client connections us…Database Connection Control Functions › Parameter Key Words