Re: GSSAPI Authentication for pgadmin4 macOS client

2020-11-02 Thread Sean McDaniel
Tom, I wasn't able to get pgadmin4 working with the symlinks, but I'm not very knowledgeable about libraries. But that's not a problem. I appreciate everyone diagnosing the issue. I'll reach out the pgsql-admin forum to see if there's a simple workaround or if a GSSAPI-enabled pgadmin4 client is

Re: Last updated time for a Schema of the table

2020-11-02 Thread hubert depesz lubaczewski
On Mon, Nov 02, 2020 at 03:23:06PM +0530, paras paliya wrote: > I need the last updated time or alter time of the table. Like changing the > column name or adding/deleting a column. Is there any table or view from > which I can get? PostgreSQL doesn't keep that information. You can: 1. set log_st

Re: Last updated time for a Schema of the table

2020-11-02 Thread PALAYRET Jacques
Hello, I don't think so, as far as I know. But, you can put in place some triggesr to do that. i.e. https://www.postgresql.org/docs/13/plpgsql-trigger.html https://wiki.postgresql.org/wiki/Audit_trigger and so on Regards De: "paras paliya" À: pgsql-gene...@postgresql.org Envoyé: Lundi

Last updated time for a Schema of the table

2020-11-02 Thread paras paliya
Hi All, I need the last updated time or alter time of the table. Like changing the column name or adding/deleting a column. Is there any table or view from which I can get? Thanks, Paras