From: | Mattias Kregert <matti(at)algonet(dot)se> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)hub(dot)org |
Subject: | Re: [HACKERS] Permissions on copy |
Date: | 1998-02-23 11:22:24 |
Message-ID: | 34F15BF0.426373FD@algonet.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 */
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-02-23 12:06:21 | Re: [HACKERS] Backend crashes - what's going on here??? |
Previous Message | Zeugswetter Andreas SARZ | 1998-02-23 11:11:52 | Re: pl/{perl,pgsql} (was Re: AW: [HACKERS] triggers, views and ru les (not instead)) |