On Tue, Oct 25, 2005 at 11:27:08AM +0530, Paresh Bafna wrote: > If there are multiple databases, say db1 and db2. > And currently we are in db1, can we create table in db2 (without > switching databases)? You could use contrib/dblink. However, if you need to do this often then it might be better to use schemas instead of separate databases. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly