[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] loading many queries from a file
From:       Szymon Guz <mabewlun () gmail ! com>
Date:       2010-06-30 22:23:52
Message-ID: AANLkTik_9_q5kzf-3NuZyB-o3IuPNUuSy9fGlYbGqHJP () mail ! gmail ! com
[Download RAW message or body]

Hi,
I've got a file with many SQL queries, also some function definitions and so
on. I'd like to load it to database, but using some library like
JDBC/ODBC/DBI, not using the obvious psql. Do you know how I could load
those many queries? Usually there could be loaded only one query, I saw that
psql parses the file looking for the semicolon.

Is there any other way than parsing the file and loading queries one by one?


regards
Szymon

[Attachment #3 (text/html)]

Hi,<div>I&#39;ve got a file with many SQL queries, also some function defin=
itions and so on. I&#39;d like to load it to database, but using some libra=
ry like JDBC/ODBC/DBI, not using the obvious psql. Do you know how I could =
load those many queries? Usually there could be loaded only one query, I sa=
w that psql parses the file looking for the semicolon.=C2=A0<div>
<br></div><div>Is there any other way than parsing the file and loading que=
ries one by one?</div><div><br></div><div><br></div><div>regards</div><div>=
Szymon</div></div>


[prev in list] [next in list] [prev in thread] [next in thread]