Execute Query

Uses raw SQL to execute a query in PostgreSQL.

Input Fields

• Query
  • Raw SQL (text): The SQL statment you wish to execute (i.e. “SELECT * FROM mytable WHERE column_name =1).
• Confirm
  • Execute Query? (T/F): Choose true to  execute the query or choose False to do a “dry run” to test the results.

Output Fields

• Result
  • Rows (list of objects): The result of the query.
  • Query (object): The query used.