On 29/09/2010 5:16 PM, Georg M. Sorst wrote:
> Hey list!
> Is there a way to load a dump with include statements (\i something.sql)
> with the Postgres JDBC driver? Both PGCopyOutputStream and the regular
> Statement seem to choke on \i.
No. \i is a psql-specific instruction. It's not part of the PostgreSQL
dialect or protocol, it's a utility command in the "psql" interactive
sql command processor.
You could probably pre-process the input stream to insert includes
pretty easily, though. Doing it properly and cleanly would require your
code to be properly aware of quoted blocks, including dollar-quoted
blocks, but in practice you can probably get away with looking for a
line-ending followed by a run of zero or more whitespace chars before \i .
Tech-related writing at http://soapyfrogs.blogspot.com/
In response to
pgsql-jdbc by date
|Next:||From: John Lister||Date: 2010-09-29 17:58:36|
|Subject: Re: selecting using array as IN condition parameter - possible?|
|Previous:||From: Oliver Jowett||Date: 2010-09-29 13:02:48|
|Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)|