On 2 Dec 2002 at 12:05, Karel Zak wrote: > On Sat, Nov 30, 2002 at 01:11:20PM -0800, Joe Conway wrote: > > As I said, this is all very preliminary; comments, suggestions, requests > > are all welcome. > Only idea/dream: what implement dblink as "virtual" schema. > CREATE SCHEMA myschema AS DBLINK TO ... some connection options ...; > SELECT * FROM myschema.tabname; > This solution allows use dblink as really transparent.
Well, that is an excellent solution but I want to suggest a further modification.. How would you select from a table in certain schema in remote database? i.e. does current implementation supports nested schemas? Like select * from remotedb.schemaa.tablea will work? If it does, this might be the best transparency we could ever get.. Bye Shridhar -- pension: A federally insured chain letter. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
