David G. Johnston wrote: > Do I understand correctly that you are proposing a slightly less > verbose alternative of: > > \o :filename > COPY TO STDOUT > \o
Not strictly the same because of this: \o or \out [ filename ] .... “Query results” includes all tables, command responses, and notices obtained from the database server, as well as output of various backslash commands that query the database (such as \d); but not error messages. If for instance psql received a notification between the two \o it would end up in the file, which it wouldn't with \copyto. The same is true for SELECT... \g file as opposed to \o file Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite
