Hi all, I would like to create a database based upon a template which also contains some tables. After invoking psql -T <templateName> -U <dbuser> -O <dbowner> test the new database 'test' belongs to <dbowner> but all tables are still belonging to the user who owns the template <templateName>. This results in the following error message when accessing the tables: ERROR: permission denied for relation <some table> Of course, I could alter the permissions in way that <dbowner> has access to all tables. But it would be much nicer, if the owner of the cloned database were inherited to all tables. Is there a way to achieve this? Thanks in advance, Stefan.
