Chris Cameron wrote:
>
> This has been working well so far, thanks.
>
> Um, looking at http://www.postgresql.org/idocs/index.php?privileges.html
> it seems to be that I'm not actually able to do what I want. Am I
> correct in believing that to let a user create tables and change tables
> in a database, they actually have to had created it? The best I can do
> is grant privileges on premade tables?
It's not as straightforward, but you should also be able to grant suitable
privileges on the metadata tables. Use \dS to list the metadata tables.
Cheers,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew@catalyst.net.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64(27)246-7091, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709