PostgreSQL interactive terminal NAME psql - PostgreSQL interactive terminal SYNOPSIS psql [ option ...] [ dbname [ username ]] DESC......into one script file. The script file contains SQL commands that can be used as input to psql (1) to restore the databases. It does this by calling pg_dump (1) for each database…...o the state it was in at the time it was saved. To restore from such a script, feed it to psql (1). Script files can be used to reconstruct the database even on other machines a…...commands SYNOPSIS client-program [ --cluster version / cluster ] [...] ( client-program : psql , createdb , dropuser , and all other client programs installed in /usr/lib/postgr…...commands SYNOPSIS client-program [ --cluster version / cluster ] [...] ( client-program : psql , createdb , dropuser , and all other client programs installed in /usr/lib/postgr…...he form FETCH count The count is the number of rows fetched (possibly zero). Note that in psql, the command tag will not actually be displayed, since psql displays the fetched r…...e use of LISTEN and NOTIFY . EXAMPLES Configure and execute a listen/notify sequence from psql: LISTEN virtual; NOTIFY virtual; Asynchronous notification "virtual" received from…...cess method. Of course, a superuser can comment on anything. Comments can be viewed using psql's \d family of commands. Other user interfaces to retrieve comments can be built a…...see Section 32.15). DIAGNOSTICS In case of difficulty, see DROP ROLE ( DROP_ROLE (7)) and psql (1) for discussions of potential problems and error messages. The database server …...ion 32.15). DIAGNOSTICS In case of difficulty, see DROP DATABASE ( DROP_DATABASE (7)) and psql (1) for discussions of potential problems and error messages. The database server …...rted by libpq (see Section 32.15). DIAGNOSTICS In case of difficulty, see CLUSTER (7) and psql (1) for discussions of potential problems and error messages. The database server …...s the default during restore. --restrict-key= restrict_key Use the provided string as the psql \restrict key in the dump output. This can only be specified for SQL script output…...rted by libpq (see Section 32.15). DIAGNOSTICS In case of difficulty, see REINDEX (7) and psql (1) for discussions of potential problems and error messages. The database server …...see Section 51.29) records information about the currently installed languages. Also, the psql command \dL lists the installed languages. To create functions in a procedural lan…...ng permissions for a whole class of objects rather than specific named objects. NOTES Use psql (1)'s \ddp command to obtain information about existing assignments of default pri…...returns a command tag of the form COPY count The count is the number of rows copied. Note psql will print this command tag only if the command was not COPY ... TO STDOUT, or the…...32.15). DIAGNOSTICS In case of difficulty, see CREATE DATABASE ( CREATE_DATABASE (7)) and psql (1) for discussions of potential problems and error messages. The database server …...rposes because it might be incomplete; however it will still consume update overhead. The psql \d command will report such an index as INVALID: postgres=# \d tab Table "public.t…...channel names and payloads. EXAMPLES Configure and execute a listen/notify sequence from psql: LISTEN virtual; NOTIFY virtual; Asynchronous notification "virtual" received from …...cleartext, and it might also be logged in the client's command history or the server log. psql (1) contains a command \password that can be used to change a role's password with…