Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
system functions Archives - PostgreSQL Candies

Event triggers in PostgreSQL 9.3 / 9.4

Well in versions 9.3 and 9.4 event triggers are something like “very good start”. You can use them quite well but it is not exactly 100% comfortable. How to use them: Create function which returns “event_trigger”. Function will end with just...

System information functions

Do you want to see all results at once? select 'current_database()' as _command, current_database() as _result, 'name of current database' as _description union all select 'current_schema()', current_schema(), 'name of current schema' union all select...