Equivalent of Oracle Advanced Queue in Postgres

Dear PostgreSQL Community Forum Members,

I hope this message finds you well. I am reaching out to inquire about the
equivalent functionality of Oracle Advanced Queue in PostgreSQL.

As we continue to explore and migrate our database solutions to PostgreSQL,
we have encountered a need for a feature similar to Oracle Advanced Queue.
In Oracle, Advanced Queue provides a messaging infrastructure that enables
asynchronous communication between applications. It allows messages to be
stored persistently in the database until they are consumed by subscribing
applications.

Could you please provide insights or recommendations on how we can achieve
similar functionality in PostgreSQL? We are particularly interested in
features or extensions within PostgreSQL that offer queuing capabilities,
message persistence, and asynchronous communication between applications.

Any guidance, best practices, or suggestions from the community would be
greatly appreciated. Additionally, if there are any existing PostgreSQL
extensions or modules that provide comparable functionality to Oracle
Advanced Queue, we would love to learn more about them.

Thank you in advance for your time and assistance. We look forward to
hearing from the knowledgeable members of the PostgreSQL community.

Best regards,

Umesh Kumar Yadav