I kind of skipped over the functions/operators section of the PostgreSQL documentation when reading it. I want to review the sections that I think would be useful to me.
current_setting(setting_name)->text: get current value of setting
set_config(setting_name, new_value, is_local)->text: set parameter value and return new value
Server Signaling Functions
pg_cancel_backend(pid int)->boolean: Cancel a backend's current query. You can execute this against another backend that has exactly the same role as the user calling the function. In all other cases, you must be a superuser
pg_terminate_backend(pid int)->boolean: Terminate a backend. You can execute this against another backend that has exactly the same role as the user calling the function. In all other cases, you must be a superuser
There are numerous functions for making on-line backups. There are functions that provide information about the current status of the standby. These functions may be executed both during recovery and in normal running.
PostgreSQL allows database sessions to synchronize their snapshots. A snapshot determines which data is visible to the transaction that is running the snapshot. Synchronized snapshots are necessary when two or more sessions need to see identical content in the database.
There are numerous functions for controlling and interacting with replication features. There are numerous functions that calculate the disk space usage of database objects. There are functions that provide native access to files on the machine hosting server. There are many functions that manage advisory locks.
Are you sure you want to delete this article section? You can not undo this change.
Add a Comment
Annotate Article
Copy Link to Selection
Share Article Selection
Ask AI About Selection
Write with AI
Rewrite Paragraph with AI
Rewrite with AI
A previous, saved version of this article is saved. To compare the current version of the article with the previous version - or to replace the current version with the saved version - click the icon above the text editor.
Successfully copied URL to clipboard!
Copied code to clipboard.
Copied TeX code to clipboard.
Uploaded file must be an image of type .jpeg, .jpg, .png, .webp, .gif, .bmp, or .svg.
Image Size must be less than 5MB.
Uploaded file must be an image of type jpeg, jpg, png, webp, avif, tiff, or svg.
Something went wrong uploading the image to the database. Try reloading the page.
The maximum number of images you can upload is 30.
There was an error taking an image using the device's camera. Try uploading an image instead.
Uploaded file must be an audio file.
Audio file must be an audio file of type .m4a, .flac, .mp3, .mp4, .wav, .wma, .aac, .webm, or .mpeg.
Audio file must be less than 300 MB in size.
Something went wrong uploading the audio file. Try reloading the page.
The maximum number of audio files you can upload is 10.
There was an error capturing an audio recording using the device's microphone. Try uploading an audio recording or video instead.
Uploaded file must be an video file.
Video file must be an audio file of type .mp4, .mov, .avi, .wmv, .avchd, .webm, or .flv.
Video file must be less than 300 MB in size.
Something went wrong uploading the video file. Try reloading the page.
The maximum number of video files you can upload is 10.
There was an error taking a video using the device's camera / microphone. Try uploading a video instead.
Comments
You can read more about how comments are sorted in this blog post.
User Comments
There are currently no comments for this article.