Search PostgreSQL documentation

dropdb --interactiveCommand-line ToolsPG18-i--interactive Issues a verification prompt before doing anything destructive.dropdb › Options dropdb --maintenance-db=dbnameCommand-line ToolsPG18--maintenance-db=dbname Specifies the name of the database to connect to in order to drop the target database. If not specified, the postgres database will be used; if that does not exist (o…dropdb › Options dropdb --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…dropdb › Options dropdb --passwordCommand-line ToolsPG18-W--password Force dropdb to prompt for a password before connecting to a database. This option is never essential, since dropdb will automatically prompt for a password if the server demand…dropdb › Options dropdb --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.dropdb › Options dropdb --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.dropdb › Options dropdb --versionCommand-line ToolsPG18-V--version Print the dropdb version and exit.dropdb › Options dropuserCommand-line ToolsPG18dropuser dropuser — remove a PostgreSQL user account Synopsis dropuser [connection-option...] [option...] [username]dropuser dropuser --echoCommand-line ToolsPG18-e--echo Echo the commands that dropuser generates and sends to the server.dropuser › Options dropuser --helpCommand-line ToolsPG18-?--help Show help about dropuser command line arguments, and exit.dropuser › Options dropuser --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.dropuser › Options dropuser --if-existsCommand-line ToolsPG18--if-exists Do not throw an error if the user does not exist. A notice is issued in this case.dropuser › Options dropuser --interactiveCommand-line ToolsPG18-i--interactive Prompt for confirmation before actually removing the user, and prompt for the user name if none is specified on the command line.dropuser › Options dropuser --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…dropuser › Options dropuser --passwordCommand-line ToolsPG18-W--password Force dropuser to prompt for a password before connecting to a database. This option is never essential, since dropuser will automatically prompt for a password if the server de…dropuser › Options dropuser --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.dropuser › Options dropuser --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as (not the user name to drop).dropuser › Options dropuser --versionCommand-line ToolsPG18-V--version Print the dropuser version and exit.dropuser › Options ecpgCommand-line ToolsPG18ecpg ecpg — embedded SQL C preprocessor Synopsis ecpg [option...] file...ecpg ecpg --helpCommand-line ToolsPG18-?--help Show help about ecpg command line arguments, and exit.ecpg › Options ecpg --versionCommand-line ToolsPG18--version Print the ecpg version and exit.ecpg › Options ecpg -cCommand-line ToolsPG18-c Automatically generate certain C code from SQL code. Currently, this works for EXEC SQL TYPE.ecpg › Options ecpg -C modeCommand-line ToolsPG18-C mode Set a compatibility mode. mode can be INFORMIX, INFORMIX_SE, or ORACLE.ecpg › Options ecpg -D symbol[=value]Command-line ToolsPG18-D symbol[=value] Define a preprocessor symbol, equivalently to the EXEC SQL DEFINE directive. If no value is specified, the symbol is defined with the value 1.ecpg › Options ecpg -hCommand-line ToolsPG18-h Process header files. When this option is specified, the output file extension becomes .h not .c, and the default input file extension is .pgh not .pgc. Also, the -c option is forced on.ecpg › Options ecpg -iCommand-line ToolsPG18-i Parse system include files as well.ecpg › Options ecpg -I directoryCommand-line ToolsPG18-I directory Specify an additional include path, used to find files included via EXEC SQL INCLUDE. Defaults are . (current directory), /usr/local/include, the PostgreSQL include directory wh…ecpg › Options ecpg -o filenameCommand-line ToolsPG18-o filename Specifies that ecpg should write all its output to the given filename. Write -o - to send all output to standard output.ecpg › Options ecpg -r optionCommand-line ToolsPG18-r option Selects run-time behavior. Option can be one of the following: no_indicator Do not use indicators but instead use special values to represent null values. Historically there have b…ecpg › Options ecpg -tCommand-line ToolsPG18-t Turn on autocommit of transactions. In this mode, each SQL command is automatically committed unless it is inside an explicit transaction block. In the default mode, commands are committe…ecpg › Options ecpg -vCommand-line ToolsPG18-v Print additional information including the version and the "include" path.ecpg › Options ecpg no_indicatorCommand-line ToolsPG18no_indicator Do not use indicators but instead use special values to represent null values. Historically there have been databases using this approach.ecpg › Options ecpg prepareCommand-line ToolsPG18prepare Prepare all statements before using them. Libecpg will keep a cache of prepared statements and reuse a statement if it gets executed again. If the cache runs full, libecpg will free …ecpg › Options ecpg questionmarksCommand-line ToolsPG18questionmarks Allow question mark as placeholder for compatibility reasons. This used to be the default long ago.ecpg › Options fallback_application_nameCommand-line ToolsPG18fallback_application_name Specifies a fallback value for the application_name configuration parameter. This value will be used if no value has been given for application_name via a connectio…Database Connection Control Functions › Parameter Key Words fillfactorCommand-line ToolsPG18fillfactor (integer) The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default. When a smaller fillfactor is specified, INSERT operations pack tabl…CREATE TABLE › Parameters › Storage Parameters gssdelegationCommand-line ToolsPG18gssdelegation Forward (delegate) GSS credentials to the server. The default is 0 which means credentials will not be forwarded to the server. Set this to 1 to have credentials forwarded when…Database Connection Control Functions › Parameter Key Words gssencmodeCommand-line ToolsPG18gssencmode This option determines whether or with what priority a secure GSS TCP/IP connection will be negotiated with the server. There are three modes: disable only try a non-GSSAPI-encryp…Database Connection Control Functions › Parameter Key Words gsslibCommand-line ToolsPG18gsslib GSS library to use for GSSAPI authentication. Currently this is disregarded except on Windows builds that include both GSSAPI and SSPI support. In that case, set this to gssapi to cau…Database Connection Control Functions › Parameter Key Words hostCommand-line ToolsPG18host Name of host to connect to. If a host name looks like an absolute path name, it specifies Unix-domain communication rather than TCP/IP communication; the value is the name of the direct…Database Connection Control Functions › Parameter Key Words