Re: [GENERAL] building extension with large string inserts
| От | Tom van Tilburg |
|---|---|
| Тема | Re: [GENERAL] building extension with large string inserts |
| Дата | |
| Msg-id | CAP3PPDg9qjuy0aKi2wKC643=5xoEknqRsfif+T_kwKuX7MqqSA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [GENERAL] building extension with large string inserts (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: [GENERAL] building extension with large string inserts
Re: [GENERAL] building extension with large string inserts |
| Список | pgsql-general |
I think I misunderstand. How would that help my insert statement?
You would get INSERT INTO mytable VALUES ($ javascript with a lot of unescaped characters like /n " // etc. $);
and: Am I correct that INSERTS are the way to go in extensions?
Best,
Tom vT.
On Wed, Jul 5, 2017 at 4:57 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 по дате отправления: