Re: table with a variable name??? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: table with a variable name???
Date
Msg-id 200409111639.51006.peter_e@gmx.net
Whole thread Raw
In response to table with a variable name???  ("William Herring" <william.herring@spgenetics.com>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Obtaining the Julian Day from a date
Next
From: Tom Lane
Date:
Subject: Re: What is the postgres version of mysql's "ON DUPLICATE KEY"