pg_tablespace.spcacl

Alexi Gen wrote:

Hello,

pg_tablespace contains information about all the tablespaces available on
the system.
The [spcacl] column for a particular record - contains a string value of
the names of users that have permissions on the tablespace.
I'm looking for any info as to why this approach was taken?
Can someone point me to a page / document?

Because it's the same approach used everywhere else? The underlying
reason is that it's more efficient than using a normalized approach.

Of course, internally they aren't strings, but arrays of ACL items,
which are in turn tuples of
(grantor ID, grantee ID, with_grant_option, privileges), stored as
three 32-bit ints. They are converted in string format only for
display, just like everything else.

Does that answer your question? If it doesn't, please be more specific.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support