Postgres Pro
Downloads
Home   >   mailing lists

Re: Can you combine text variable together to referenece a VIEW name ? - Mailing list pgsql-general

From Lew
Subject Re: Can you combine text variable together to referenece a VIEW name ?
Date
Msg-id GqudnTVv2a32pIfbnZ2dnUVZ_sDinZ2d@comcast.com
Whole thread Raw
In response to Can you combine text variable together to referenece a VIEW name ?  ("Bigjim" <bigjim.still@rogers.com>)
List pgsql-general
Tree view 
Bigjim wrote:
> Hi there,
> I am trying to combine 2 text variable togther to form the name of a
> VIEW.  example
>
>
>    SELECT * FROM ( 'april'||'may') ;

The table (or view) part is not a character string but an identifier.

--
Lew

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: backend reset of database
Next
From: "Andrus"
Date:
Subject: How to disable duplicate columns