Re: psql problem

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