Query table based on table_name from information_schema
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2024 12:34 PM
Hi,
I have one table that changes the name every 60 days. The name simple increases the number version, for example:
* Firtst 60 days: table_name_v1. After 60 days: table_name_v2 and so on.
What i want is to query the table wich name returned in the query of information_schema. This is important because when the name change, I won't need to adapt the query name.
Here is a example of what I want.
CREATE OR REPLACE TEMP VIEW db_copart AS
SELECT
table_name
FROM information_schema.tables
WHERE
table_schema = 'table_sandbox'
and table_name ILIKE '%db_pi_copart_v%'; -- this will return the latest table version
SELECT
*
FROM table_sandbox.(select table_name from db_copart)
Thank you all for any help.
Thank you all for any help.
