Table name as a variable in SELECT query

From: "Andrey Fokin" <affox(at)myway(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Table name as a variable in SELECT query
Date: 2010-12-18 12:46:38
Message-ID: 20101218074638.18205@web014.roc2.bluetie.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2010-12-18 14:01:04 Re: Table name as a variable in SELECT query
Previous Message Luiz K. Matsumura 2010-12-17 19:01:46 Re: UPDATE in a specific order