Hi, I am using Redhat linux 9 with postgreSQL 7.4.5. It contain 3 database such as postgres, template0 template1. If i want to create mydb where i have to create. Either i have to login as us postgres , and create mydb or under psql template1 and create mydb or under psql template0 and create mydb -- Warm Regards, S.ElayaRaja Mobile: (+91) 98450 59540 E-Mail: elayaraja.s@xxxxxxxxx raja_nk@xxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match