table with a variable name???

Started by William Herringover 21 years ago2 messagesgeneral
Jump to latest
#1William Herring
william.herring@spgenetics.com

I would like to create a temporary table with a variable name. For example,
the name of the table might be based on some form of datetime and a constant
text. I have looked through the logs, but have not found any direction on
this. Any ideas?

#2Peter Eisentraut
peter_e@gmx.net
In reply to: William Herring (#1)
Re: table with a variable name???

William Herring wrote:

I would like to create a temporary table with a variable name. For
example, the name of the table might be based on some form of
datetime and a constant text. I have looked through the logs, but
have not found any direction on this. Any ideas?

You will have to compute the table name in your client application or a
server-side procedure, paste it into the command string, and execute
that.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/