SELECT book.title, book.author, book.feedback
FROM postgresql_admin_community
JOIN books ON book.subject ILIKE '%postgres%'
JOIN readings ON readings.reader_id = postgresql_admin_community.id
WHERE
postgres_admin_community.user_experience_level = 'I have spent years
around databases, but never real
Mikel Lindsaar wrote:
I have done this so far by reading a lot of the Postgres manual and
every website I can find.
Books usually just recycle that information. PostgreSQL's manual is
really good today. Add Greg Smith's PostgreSQL Performance Pitstop, a
few other sites and you have everything
Is there a way to grant a permission on a table for a role and have that
cascade to the child tables ?
I have several high volume "daily" partitioned tables that get dropped
every week and every time I need to re-grant permission on the new
tables created.