Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Using Execute with Dynamic Raise Commands



Robert Bernabe <rbernabe(at)sandmansystems(dot)com> writes:
>    I've been trying to create a debugging function that would receive a 
> tablename and a list of columns and then the function would display all 
> the contents of the table using the RAISE command.

There's no such thing as a "dynamic raise command" --- EXECUTE is for
executing regular SQL statements, not plpgsql things.  You hardly need
anything dynamic in your example anyway, seeing that you've built up
the string you want to display just fine.

			regards, tom lane



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group