Ivan Kalik wrote:
Of course not by hand. Yes, there are procedures for creating databases, users, assigning users to databases, giving them permissions etc., even reading input from a file (there are actually several options for doing that). Perhaps you should first find out what these things are for:
http://www.postgresql.org/docs/manuals/
Ivan Kalik Kalik Informatika ISP
Ivan:
I have gone through all 2,000+ pages of the manual you mentioned. Somehow I missed answer to my question. Will you be kind enough to let me know the chapter where it discusses creating data using a text file?
psql. You have a \ command option, - (--) comand option, or even good old < way to do it. I haven't seen a guide on posgresql that doesn't describe at least one of these ways of importing command from a file. Ivan Kalik Kalik Informatika ISP