Table name as a variable in SELECT query - Mailing list pgsql-sql

From Andrey Fokin
Subject Table name as a variable in SELECT query
Date
Msg-id 20101218074638.18205@web014.roc2.bluetie.com
Whole thread Raw
Responses Re: Table name as a variable in SELECT query
List pgsql-sql
Hi,
please advise is possible in SELECT query use variable as a table name?

I would like to have  for example something like:

CREATE OR REPLACE FUNCTION test_name (tb varchar) RETURNS int AS  $$

DECLARE
                ......

BEGIN    SELECT * FROM $1;    ........

Will be grateful for any idea about.


Best regards           Andrey


pgsql-sql by date:

Previous
From: "Luiz K. Matsumura"
Date:
Subject: Re: UPDATE in a specific order
Next
From: Andreas Kretschmer
Date:
Subject: Re: Table name as a variable in SELECT query