Re: how to change line terminator

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Siddharth Saha <siddharthsaha(at)drishti-soft(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: how to change line terminator
Date: 2010-07-12 15:44:34
Message-ID: 201007121544.o6CFiY029808@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Hodgson 2010-07-12 15:57:59 Re: SQL from Linux command line
Previous Message Tom Lane 2010-07-12 15:44:10 Re: Join Scalability