Last updated time for a Schema of the table

[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

Re: Last updated time for a Schema of the table

[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 2 Novembre 2020 10:53:06 
Objet: Last updated time for a Schema of the table 

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 

Re: Last updated time for a Schema of the table

[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_statement to ddl (or more) to log all schema changes
2. use event triggers to do whatever you want at the time of change.

Best regards,

depesz

Re: GSSAPI Authentication for pgadmin4 macOS client

[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 in the pipeline. If not, I have other
GUI or CLI programs I can use.

Regards,

Sean

On Tue, Oct 27, 2020 at 3:45 PM Tom Lane  wrote:

> Sean McDaniel  writes:
> > I followed your suggestions and symlinked libpq.5.dylib under
> > /Applications/pgAdmin 4.app/Contents/Frameworks to the homebrew library
> > /usr/lib/libpq.5.6.dylib, but unfortunately pgadmin4 now fails on launch
> > with the error "The pgadmin4 server could not be contacted." Do the other
> > libraries 'libcrypto.1.1.dylib' and 'libssl.1.1.dylib' need symlinked as
> > well? They don't appear to have exact library matches under /usr/lib.
>
> Yeah, probably.  Try "otool -L" on the symlink and see if it manages
> to resolve all the dependencies.
>
> Another point here is that libpq.5.6.dylib is quite a few major versions
> back, so it's possible that pgadmin needs a newer version of that library.
> Hard to tell what's going on unless you can find some lower-level error
> report.
>
> > Also, might a future macOS version of pgadmin4 support GSSAPI?
>
> You'd have to pester the pgadmin folk about that.
>
> regards, tom lane
>