COPY manual is ambiguous about column list

2019-11-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-copy.html Description: "If a list of columns is specified, COPY will only copy the data in the specified columns to or from the file. If there are any columns in the table that are not

document effect of USAGE on foreign server to dblink

2019-11-27 Thread Jeff Janes
I think that the permissions around the usage of foreign server names as connection names in dblink should be documented, as in the attached. Also, for dblink itself it says "It is recommended to use the foreign-data wrapper dblink_fdw when defining the foreign server". Is there a reason for this

Re: Example not producing shown output

2019-11-27 Thread Daniel Gustafsson
> On 26 Nov 2019, at 19:28, Alvaro Herrera wrote: > Or perhaps we can add a second line in the example cell for the > @@ operator, to make it clear that both forms can be used. Users can be > expected to apply some intuition from that point onwards. Wouldn't it be more intuitive to add such a s