• 1. How do I know what values are on the row object?
  • 2. Can I iterate across the columns in the recordset to dynamically display column names?
  • 3. Assuming a recordset is enumerated using the array accessor style used in 1, can we get the column names in the same fashion, i.e. is there a result.rows[i].columnName property?
  • 4. How do you get the count of columns in the result set?
  • 5. If pg returns query data in JSON format, for web service applications, it would make sense to return that directly to the client. If this assumption is correct what is the most efficient method?
  • 6. How do I use the Client instance directly?
  • 7. I just have a question and maybe a feature request that i am not able to think about how to implement or do it: i need to retrieve the inserted row or someway to reach it after the insert is done.
  • 8. Does node-postgres handle SQL injection?
  • 9. Can I create a named prepared statement for use later on without performing a query? If not, does passing the same text again to a named statement get ignored and the cached version used? I don't want to have two codepaths in a function, one for first-use and one for every other.
  • 10. Can we override the built in data converters between javascript and postgres data types?
  • 11. How do I build a WHERE foo IN (...) query to find rows matching an array of values?
  • 12. Why does node-postgres come with two bindings? One in Javascript and one "native" that uses libpq? Which one is fastest and why isn't a single binding enough?
  • 13. What happens to open transactions when pg.connect's done is called?
  • 14. How do I install pg on Windows?
  • 15. (New Question) How can a quickly get a Client from Client pool?
  • 16. (New Question) Are queries asynchronous, or do they block? Can this behavior be overridden if desired?
  • 17. What happens if I ask for a connection and the pool is already empty? will it throw an error or wait until a connection becomes available?
  • 18. (New Question) Is there a way to check if I have an active connection?
  • 19. I obtain Promise { <pending> } from a query