Re: [GENERAL] data dump help

2010-01-19 Thread Terry
On Tue, Jan 19, 2010 at 12:06 AM, Johan Nel wrote: > Terry wrote: >> >> Hello, >> >> Sorry for the poor subject.  Not sure how to describe what I need >> here.  I have an application that logs to a single table in pgsql. >> In order for me to get into our log management, I need to dump it out >> t

Re: [GENERAL] data dump help

2010-01-18 Thread Johan Nel
Terry wrote: Hello, Sorry for the poor subject. Not sure how to describe what I need here. I have an application that logs to a single table in pgsql. In order for me to get into our log management, I need to dump it out to a file on a periodic basis to get new logs. I am not sure how to tack

Re: [GENERAL] data dump help

2010-01-18 Thread Bret S. Lambert
On Tue, Jan 19, 2010 at 06:35:10PM +1300, Andrej wrote: > 2010/1/19 Bret S. Lambert : > > > Isn't this just over-engineering? Why not let the database do > > the work, and add the column with a default value of 0, so that > > you don't have to modify whatever 3rd-party app dumps the data: > > But

Re: [GENERAL] data dump help

2010-01-18 Thread Andrej
2010/1/19 Bret S. Lambert : > Isn't this just over-engineering? Why not let the database do > the work, and add the column with a default value of 0, so that > you don't have to modify whatever 3rd-party app dumps the data: But what if his third-party software does something silly like a "select

Re: [GENERAL] data dump help

2010-01-18 Thread Bret S. Lambert
On Mon, Jan 18, 2010 at 05:49:32PM -0600, Terry wrote: > On Mon, Jan 18, 2010 at 5:07 PM, Terry wrote: > > On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote: > >> On 1/18/2010 4:08 PM, Terry wrote: > >>> > >>> Hello, > >>> > >>> Sorry for the poor subject. ?Not sure how to describe what I need >

Re: [GENERAL] data dump help

2010-01-18 Thread Terry
On Mon, Jan 18, 2010 at 5:07 PM, Terry wrote: > On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote: >> On 1/18/2010 4:08 PM, Terry wrote: >>> >>> Hello, >>> >>> Sorry for the poor subject.  Not sure how to describe what I need >>> here.  I have an application that logs to a single table in pgsql.

Re: [GENERAL] data dump help

2010-01-18 Thread Terry
On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote: > On 1/18/2010 4:08 PM, Terry wrote: >> >> Hello, >> >> Sorry for the poor subject.  Not sure how to describe what I need >> here.  I have an application that logs to a single table in pgsql. >> In order for me to get into our log management, I n

Re: [GENERAL] data dump help

2010-01-18 Thread Andy Colson
On 1/18/2010 4:08 PM, Terry wrote: Hello, Sorry for the poor subject. Not sure how to describe what I need here. I have an application that logs to a single table in pgsql. In order for me to get into our log management, I need to dump it out to a file on a periodic basis to get new logs. I a

[GENERAL] data dump help

2010-01-18 Thread Terry
Hello, Sorry for the poor subject. Not sure how to describe what I need here. I have an application that logs to a single table in pgsql. In order for me to get into our log management, I need to dump it out to a file on a periodic basis to get new logs. I am not sure how to tackle this. I tho