Home > mailing lists

Re: [ADMIN] Analyze Table - Mailing list pgsql-admin

From	David G. Johnston
Subject	Re: [ADMIN] Analyze Table
Date	August 18, 2017 22:59:32
Msg-id	CAKFQuwa+oiyGMj5Qb1V9w6i_+CVZpzBR-D2ywX53G-xUD5SQJw@mail.gmail.com Whole thread Raw
In response to	[ADMIN] Analyze Table (anand086 <anand086@gmail.com>)
Responses	Re: [ADMIN] Analyze Table
List	pgsql-admin

On Fri, Aug 18, 2017 at 9:50 AM, anand086 <anand086@gmail.com> wrote:

What is the best possible way to get the table analyzed from application
code without changing granting owner to dev_user?

A solution is to write a "SECURITY DEFINER" function.

David J.

From: anand086
Date: 18 August 2017, 22:50:47
Subject: [ADMIN] Analyze Table

From: anand086
Date: 18 August 2017, 23:13:12
Subject: Re: [ADMIN] Analyze Table