Re: [GENERAL] building extension with large string inserts - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] building extension with large string inserts
Date
Msg-id 19243.1499266632@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] building extension with large string inserts  (Tom van Tilburg <tom.van.tilburg@gmail.com>)
Responses Re: [GENERAL] building extension with large string inserts  (Tom van Tilburg <tom.van.tilburg@gmail.com>)
List pgsql-general
Tom van Tilburg <tom.van.tilburg@gmail.com> writes:
> I am trying to build an extension where there is the need to insert large
> strings consisting of javascript code.
> ...
> What would be a proper way to get this code into a table via an extension?
> I've been working on generating INSERT statements for the extension's sql
> file but it seems a tedious job to escape the code myself.

Can't you use a dollar-quoted string?  You just need to pick a delimiter
that doesn't appear anywhere in the javascript, say $JaVaScRiPt$ ...

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Invalid field size
Next
From: Tom van Tilburg
Date:
Subject: Re: [GENERAL] building extension with large string inserts