Postgres Dynamic Query Function

by

You cannot use a variable in place of an identifier like that. You need to do it with dynamic queries. It will look something like this:

EXECUTE 'SELECT * FROM ' || quote_ident(tname) 
        || ' WHERE ' || quote_ident(cname) || ' NOT IN (''AK'',''CK'');'
INTO result_var;

If you are using PostgreSQL 9.1 or above, you can use the format() function which makes constructing this string much easier.

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. Is SELECT or INSERT in a function prone to race conditions?
  3. Difference between language sql and language plpgsql in PostgreSQL functions
  4. How to return result of a SELECT inside a function in PostgreSQL?
  5. Pass multiple values in single parameter
  6. GROUP BY and aggregate sequential numeric values
  7. PL/pgSQL checking if a row exists
  8. PostgreSQL parameterized Order By / Limit in table function
  9. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  10. PostgreSQL IF statement
  11. Call a set-returning function with an array argument multiple times
  12. Record returned from function has columns concatenated
  13. Return setof record (virtual table) from function
  14. Window Functions or Common Table Expressions: count previous rows within range
  15. DROP FUNCTION without knowing the number/type of parameters?
  16. Postgres function returning table not returning data in columns
  17. Return multiple columns and rows from a function PostgreSQL instead of record
  18. COPY with dynamic file name
  19. pseudo_encrypt() function in plpgsql that takes bigint
  20. How to perform a select query in a DO block?
  21. Function with SQL query has no destination for result data
  22. Postgres trigger after insert accessing NEW
  23. What is the difference between single quotes and double quotes in PostgreSQL?
  24. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  25. Best way to count rows by arbitrary time intervals
  26. PostgreSQL sequence based on another column
  27. postgres – where in (list) – column does not exist
  28. incomplete information from query on pg_views [duplicate]
  29. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  30. How to detect query which holds the lock in Postgres?

Leave a Comment