Nick Barnes questions

Nick Barnes answers

• Are queries in the WITH statement executed in a single transaction in PostgreSQL?
• postgresql libpqxx: Several queries as one transaction
• Logging PostgreSQL interactive queries
• how to grant execute to pgcrypto digest function to user
• Can the foreign data wrapper fdw_postgres handle the GEOMETRY data type of PostGIS?
• In PostgreSQL, weird issue about citext performance?
• Is it safe to drop and then create the foreign key constraints inside a transaction?
• How to find if a function exists in PostgreSQL and where?
• postgres INSERT trigger fires even with ON CONFLICT DO NOTHING
• Postgresql COPY encoding, how to?