Thread

Re: [HACKERS] Permissions on copy

Mattias Kregert <matti@algonet.se> — 1998-02-23T11:22:24Z

Bruce Momjian wrote:
> 
> Yes, I agree the Informix way of having load/unload, and having a SELECT
> capability so you can dump any data/join you want, not just a single
> table.  Do I have votes to put this on the TODO list?


I guess this means that it would be possible to load (for example)
a file with 2 columns into a table with 3 columns? Like this:
  load "my2columnsfile" insert into mytable (mycol13, mycol1);

Another thing which would be nice is to be able to select only some
of the columns from the file, like this:
  load myfile(1,2,5) insert into mytable (x, y, z);

This would be very useful (for me, at least).


The 'raw' COPY should be restricted to superuser only, so that no user
can bypass views, triggers and so on.

/* m */