Re: massive quotes?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: massive quotes?
Date: 2003-09-11 09:40:44
Message-ID: 3F60431C.7000108@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Richard Huxton wrote:

>On Thursday 11 September 2003 09:33, Andreas Pflug wrote:
>
>
>>*NO PARSING*
>>The script must be stuffable into PQexec in total, backend does the rest.
>>
>>Again: not psql, but sql language itself must provide this.
>>
>>No out-of-band, because this would require splitting the script in pieces.
>>
>>
>
>What's wrong with re-using the COPY FROM format?
>

I must be writing a completely ununderstandable english, sorry for that.

*NO PARSING*, I don't know how to express this differently.

What I'm saying all the time that a single sql script file containing a
huge number of statements including function creation must be executable
without parsing it, splitting it into parts and stuffing the data into
different functions.

When creating a new instance of a database for an app, I don't create
each object one by one interactively, but use a script for this. To
create the script, I certainly won't use psql and some arbitrary editor,
but a frontend allowing for editing and executing that script.

Regards,
Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jon Jensen 2003-09-11 11:31:21 Re: massive quotes?
Previous Message Richard Huxton 2003-09-11 09:20:35 Re: massive quotes?