Hi, i encounter a question when create database schema. because i have a sql script, in which contains lots of sql command, including insert, create table, create index and so on. however, i do know weather postgresql supports batch executing sql script or not, for i try to run scrtip like what oracle does; yet it seemly doesn't work. would anyone please to telll me how to do that? (i read the document - http://www.postgresql.org/docs/8.0/static/index.html - but seemly there ain't no such description in it) i appreciate any suggestion, sincerely. jason Send instant messages to your online friends http://uk.messenger.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings