[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Postgres Access Timing


Is this injection part of an ongoing process or just a one-time import of data?

If you're only going to do this once then you might want to try importing the data by using a spreadsheet to construct the necessary SQL INSERT statements. It will load slower than your program would load them but depending on the amount data it's tolerable.

Here's what I do...

Copy the data into a spreadsheet.

Re-order and/or duplicated the columns of data as necessary for the next step

Insert empty columns and place SQL fragments in these new columns

You can create multiple inserts on the same line (for multiple tables for example) by separating them with a semi-colon and duplicating columns of data as required.

When the syntax is correct then export it as a delimited file (for example, delimited by a pipe character: | ). Use an programmable editor (like VIM, JEdit, bbedit, etc.) to remove all the pipe characters and the resulting file can be executed from the command line. (in VIM I just enter the following command to remove the delimiters all at once):

You can also insert several sample rows in the tables and then dump them them and modify the dump file to contain your entire data set. I believe that data is tab-delimited.

Hope this helps,


beamends wrote:
Hi All,
not strictly a LSMB thing, but as the answer may be of interest to
others here goes... (excuse the terminology, I'm not of the dbase expert

I'm "injecting" data into Postgres using a C program via libpq. From the
documentation it's not clear if the various functions check/wait to see
if a dbase command has been or can be completed before returning from
the function ("locking"?). All is tickety-boo except when creating a new
part. When the new part is created the next line is to create the
partsvendor table entry. This works ok for most of the time, but will
start failing after a while with the INSERT into partsvendor failing.
Doing the command from the SQL window in phppgadmin will then work.
Presumably this is a timing issue or such. So the question is, is there
and SQL or Posgres command to interrogate the dbase to see if it is
"ready" for the next command. Or am I barking up the wrong tree

Ledger-smb-users mailing list

#  Eric Lucas              | Email:   ..hidden..
#  Lucii.com               | Website: www.lucii.com
#  PO Box 5301             | Phone:   610-541-0774 or 484-889-3240
#  Springfield Pa. 19064   | Mobile:  610-715-6881