On Mon, 13 Dec 2004 09:27:04 +0530 Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > and while on this topic, how does one interpret the line numbers one > gets when running psql -f to create tables?
Forget about line numbers. Add the -e option and your statements will show up in your output. Here is a sample (Unix) command line that I commonly use to run statements from a file: psql table -f in.file -e > out.file 2>&1 Now I can search the file for "ERROR" and see exactly what preceded it. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
