This is an operation that runs a SQL COPY command, but instead of the backend reading or writing the specified file, and consequently requiring backend access and special user privilege, psql reads or writes the file and routes the data to or from the backend. The default tab delimiter is used. For large amounts of data this other technique may be preferable. This meta-command can be useful to get a quick description of a native Postgres feature. List only indexes.
List only sequences.
Edit the current query buffer or the contents of the file filename . Edit the current query buffer or the contents of the file filename and execute it upon editor exit. Set the field separator. Default is a single blank space. Send the current query input buffer to the backend and optionally save the output in filename or pipe the output into a separate Unix shell to execute command .