Thanks all for your tips and pointers.
Looking at copy I think it may do just what I need. The tables I load
the data into have the same columns in the same order as those in the
CSV file. Loading data in this manner is going to be a rare occurance -
just when we install a new customer site an
I've also used Pentaho Data Integration (previously known as Kettle)
quite extensively, and can recommend it. It supports many different
databases and has fairly good documentation (although thin in some
areas). It has a GUI drag-and-drop tool that can be used to configure
transformations and is
Besides being easy to schedule and very flexible, manipulating data
with queries is extremely powerful and fairly easy to maintain
assuming you know a little SQL -- thanks to postgresql's huge array of
built in string manipulation functions. Your skills learned here will
pay off using the databas
On 1/26/07, Tomi N/A <[EMAIL PROTECTED]> wrote:
2007/1/23, Paul Lambert <[EMAIL PROTECTED]>:
> Is there an equivalent in Postgres to the DTS Packages available in M$
> SQL server.
what you're looking for exists in a number of variations.
You can use a good text editor with the postgres' COPY c
2007/1/23, Paul Lambert <[EMAIL PROTECTED]>:
G'day,
Is there an equivalent in Postgres to the DTS Packages available in M$
SQL server.
I use these in SQL server to pre-load data from CSV files prior to
enabling replication from my primary application. Any pointers on where
best to go for this
