This does the JOB...thank you very much
Oliver Elphick <[EMAIL PROTECTED]> wrote: On Tue, 2007-05-29 at 10:21 -0700,
Marsha Ramsey wrote:
> Hello all,
>
> How do I GRANT SELECT to all my tables at once? I have over 1026
> tables in this database...
I don't think there is any direct SQL co
On Tue, 2007-05-29 at 10:21 -0700, Marsha Ramsey wrote:
> Hello all,
>
> How do I GRANT SELECT to all my tables at once? I have over 1026
> tables in this database...
I don't think there is any direct SQL command to do it. But try this:
psql -d your_database
\t
\a
\o /tm
Hello all,
How do I GRANT SELECT to all my tables at once? I have over 1026 tables in
this database...
Thanks...Marsha
-
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.