bma questions

bma answers

• How to export the result set of a postgres query in a format that is importable with psql?
• How to create a PostgreSQL index that includes Latitude/Longitude (using GIST), but also regular fields
• Store the day of the week and time?
• Postgresql creating users with a function
• Adding leading zero if length is not equal to 10 digit using sql
• Dynamic table partitioning in postgres
• Speeding up checking of IP address membership in CIDR ranges, for large datasets
• Postgres Array Prefix Matching
• PostgreSQL 9.0.13 doing a pg_restore but no evidence that disk space is being used
• update table with limit and offset in postgres