Hello
I have a database in Postgres 9 with 75 tables, all have the exact same definition except for the name of the table.
Each one contains data for people who are doctors (table name = doctors), nurses (table name = nurses) etc. etc.
How can I do a select to find a given person's name (a single field) without mentioniing all 75 table names ? I do not need to know fron which table it came, just need to know if it exists.
Is there a "select * from * where *.name ='Joe Blow';" kind of syntax ?
I could join all tables into one to do the search but we want to keep data separated due to volume.
Thanks