Re: table with a variable name???

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "William Herring" <william(dot)herring(at)spgenetics(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: table with a variable name???
Date: 2004-09-11 14:39:51
Message-ID: 200409111639.51006.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2004-09-11 14:54:59 Re: Obtaining the Julian Day from a date
Previous Message William Herring 2004-09-11 14:04:54 table with a variable name???