PLPythonu doesn't allow to set all possible fields in PostgreSQL exception. Setting DETAIL and HINT fields in PLPythonu exception Psql -At -c "select 'VACUUM ANALYZE pg_catalog.'||table_name from information_schema.tables where table_schema = 'pg_catalog' and table_type 'VIEW'" db_test \ PGOPTIONS="-c log_min_duration_statement=0" pg_dump -s postgres > /dev/null Next example ensure log all statements of pg_dump: You can enforce additional libpq connection string options with system variable PGOPTIONS. Log all SQL statements generated by application 36 from Russian alphabet (Cyrillic) to ASCII.34 Barrier against to unwanted conversion char(n) to text.33 Enforcing some chars in to_char function.32 Iteration over RECORD variable inside trigger.31 Dynamic modification some record's field.29 Simply age calculation from birth date.27 Emacs's configuration for PLpgSQL syntax highlighting when function is edited from console.24 Enforcing unique name for cursor in PL/pgSQL.22 Delete duplicate rows with window analytic functions.21 Searching gaps in time series with window analytic functions.20 Taking first unlocked row from table.17 Simply query result processing in bash.14 Using custom casting when you migrate from Oracle to PostgreSQL.13 Getting N unique most similar values with usage KNNsearch and pg_tgrm module. 12 Overwriting a application name in psql (for psql based script identification).8 How to unnest an array with element indexes.7 Passing parameters from command line to DO statement.6 Fast replacing a index of PRIMARY KEY constraint.5 Debugging communication between PostgreSQL and client.3 Setting DETAIL and HINT fields in PLPythonu exception.1 Log all SQL statements generated by application.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |