...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 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…...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…...endian byte order). Binary cursors should be used carefully. Many applications, including psql, are not prepared to handle binary cursors and expect data to come back in the tex…...server log. The command createuser (1), however, transmits the password encrypted. Also, psql (1) contains a command \password that can be used to safely change the password lat…...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…