On Sun, Apr 24, 2005 at 02:08:33PM +0100, neo anderson wrote: > > 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?
>From within psql you can run "\i filename"; from the command line you can run "psql -f filename" or, if your shell supports redirection, "psql < filename". See the psql documentation for details: http://www.postgresql.org/docs/8.0/interactive/app-psql.html If that's not what you're looking for, then please provide more information about what you're trying to do. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
