Timeline for Query across multiple schemas, unknown until execution time
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29, 2015 at 23:29 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
trim noise, clarify title
|
| Mar 24, 2014 at 1:59 | history | tweeted | twitter.com/#!/StackDBAs/status/447915536937394176 | ||
| Mar 23, 2014 at 18:58 | history | edited | Erwin Brandstetter |
edited tags
|
|
| Mar 23, 2014 at 18:57 | answer | added | Erwin Brandstetter | timeline score: 11 | |
| Mar 23, 2014 at 11:15 | comment | added | Craig Ringer |
Use dynamic SQL - PL/PgSQL with EXECUTE.
|
|
| Mar 23, 2014 at 3:39 | answer | added | LR1234567 | timeline score: 1 | |
| Mar 22, 2014 at 17:12 | comment | added | larkmullins | Yes, all schemas will have the exact same tables with each table structured exactly the same. | |
| Mar 22, 2014 at 17:10 | comment | added | Fabrizio Mazzoni | Is the table in all the schemas exactly the same? | |
| Mar 22, 2014 at 16:58 | comment | added | larkmullins | Fabrizio, thank you for your respone. Is there is a way to accomplish this in a view instead of a function? | |
| Mar 22, 2014 at 16:28 | history | edited | user1822 | CC BY-SA 3.0 |
added 6 characters in body
|
| Mar 22, 2014 at 16:14 | comment | added | Fabrizio Mazzoni | You could write down a function that will query the pg_namespace table (which contains all the schemas in the DB) and then run the query against every table in the schema if exists. | |
| Mar 22, 2014 at 15:22 | review | First posts | |||
| Mar 22, 2014 at 15:33 | |||||
| Mar 22, 2014 at 15:06 | history | asked | larkmullins | CC BY-SA 3.0 |