Search code examples
postgresql-9.3squirrel-sql

exec for functions and stored procedures on squirrel-sql


I am trying to run a function on Squirrel connected to PostgresDB. I am unable to execute functions or stored procedures. example: when i run

exec pglog_read('Thu');

I get the following error

Error: ERROR: syntax error at or near "exec"
  Position: 1
SQLState:  42601
ErrorCode: 0

Am i Missing anything.

I have checked for plugins and the following have been installed. list of plugins on my squirrel client


Solution

  • As documented in chapter Calling Functions of the manual, use select:

    select pgload_read('Thu');