Hi,
I amusing ODBC to connect to a number of ODBC linked PostgreSQL dBs. They all have the same table names and as such they import themselves as something like:
public.accounts
public.accounts1
public.accounts2
I have renamed these locally and manually, so they now read:
client1.accounts
client2.accounts
client3.accounts
Does anyone know if there is a bulk or automated way to rename the local names of these linked tables?
Cheers
James