Обсуждение: table with a variable name???

Поиск
Список
Период
Сортировка

table with a variable name???

От
"William Herring"
Дата:
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?



Re: table with a variable name???

От
Peter Eisentraut
Дата:
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/