Thread: remove log header

Hi there,

On Windows, I run a script batch file with psql, and I get any log line with
the following pattern:

            psql://<path_file_name>:4: NOTICE: <log_message>

I'd like to remove the log header before NOTICE. What should I do ?

Thanks,
Sabin

On Tue, Jan 6, 2009 at 3:32 PM, Sabin Coanda <sabin.coanda@deuromedia.ro> wrote:
> Hi there,
>
> On Windows, I run a script batch file with psql, and I get any log line with
> the following pattern:
>
>            psql://<path_file_name>:4: NOTICE: <log_message>
>
> I'd like to remove the log header before NOTICE. What should I do ?

either write simple program for that, or install gnu utils and treat
it with "sed"

--
GJ

"Sabin Coanda" <sabin.coanda@deuromedia.ro> writes:
> On Windows, I run a script batch file with psql, and I get any log line with
> the following pattern:
>             psql://<path_file_name>:4: NOTICE: <log_message>
> I'd like to remove the log header before NOTICE. What should I do ?

If you don't want line numbers at all, I think you can do

    psql database <scriptfile

so that psql doesn't know it's a script.

            regards, tom lane