Postgresql Function's

Highlighted
Silver Adventurer

Postgresql Function's

Hi,

         How can i replace this function in version postgresql 10.

 

select pg_xlogfile_name(pg_current_xlog_location()) --it is 9.6 and how to change in 10V?

 

 

Reagrds

Diny.

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 REPLY 1
Highlighted
Level 3 Adventurer

Re: Postgresql Function's

Hi Diny,

You can use the below query:

select pg_walfile_name(pg_current_wal_lsn()) ;

You may refer the below links forto compare the function names.
https://www.postgresql.org/docs/10/functions-admin.html
https://www.postgresql.org/docs/9.6/functions-admin.html

 

Kindly let us know in case of any concern.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks