![]() Note however that Readline is not used in this case (much as if -n had been specified). Using this option is subtly different from writing psql < filename. In general, both will do what you expect, but using -f enables some nice features such as error messages with line numbers. There is also a slight chance that using this option will reduce the start-up overhead. ![]() On the other hand, the variant using the shell's input redirection is (in theory) guaranteed to yield exactly the same output you would have received had you entered everything by hand. ![]() Use separator as the field separator for unaligned output. This is equivalent to \pset fieldsep or \f. 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. This is equivalent to \pset format html or the \H command. Other non-connection options are ignored. This is similar to the meta-command \list. When this option is used, psql will connect to the database postgres, unless a different database is named on the command line (option -d or non-option argument, possibly via a service entry, but not via an environment variable). Write all query output into file filename, in addition to the normal output destination. nĭo not use Readline for line editing and do not use the command history. This can be useful to turn off tab expansion when cutting and pasting. Specifies the TCP port or the local Unix-domain socket file extension on which the server is listening for connections.
0 Comments
Leave a Reply. |