Gary Fu pisze:
I have a script to create a table with some comments in front. When I
use the command 'psql -f script.sql' to load it, it hangs. However,
if I remove the comments, OR remove some of the columns from the
table, it works okay. It looks like to me, the psql will hang with
large size of the script file. I tried 'psql < script.sql' and 'cat
script.sql | psql' with the same result.
you may eventually track the progress more verbosely with -a switch to
psql and this way isolate the part where it hangs
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general