Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.
Read OriginalThe article details a new feature in the upcoming PostgreSQL 19: a psql PROMPT variable (%S) that displays the current search_path. This is useful for developers and DBAs who work with databases containing many schemas, as it provides immediate visibility into the active search path. The post explains the commit, its functionality (which requires PostgreSQL v18+), and includes example usage.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
1
The Beautiful Web
Jens Oliver Meiert
•
2 votes
2
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane
•
1 votes
3
LLM Use in the Python Source Code
Miguel Grinberg
•
1 votes
4
Wagon’s algorithm in Python
John D. Cook
•
1 votes
5
An example conversation with Claude Code
Dumm Zeuch
•
1 votes