Re: how to change line terminator - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: how to change line terminator
Date
Msg-id 201007121544.o6CFiY029808@momjian.us
Whole thread Raw
In response to how to change line terminator  (Siddharth Saha <siddharthsaha@drishti-soft.com>)
List pgsql-novice
Siddharth Saha wrote:
> how to change line terminator/delimiter. Currently for me it is semicolon.
> So when I am writing a function on the CLI, it stops when encountering a
> semicolon in a statement like
>
>  val := 1;
>
> before the function end.

The entire function body needs to be in a quoted block, or $$.  Can you
show us the command and error?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Join Scalability
Next
From: Richard Broersma
Date:
Subject: Re: