[GENERAL] Re: [HACKERS] getting at the actual int4 value of an abstime

1999-08-18 Thread Tom Lane
[EMAIL PROTECTED] (Jim Mercer) writes: [ concern about speed of converting datetime values to/from text for Postgres ] FWIW, I used to be really concerned about that too, because my applications do lots of storage and retrieval of datetimes. Then one day I did some profiling, and found that

Re: [GENERAL] CVS Import/Export

1999-08-18 Thread The Hermit Hacker
There is a COPY command that you can use...there is a man page for it, sorry, don't use it myself, so dont know the syntax :( I've never had much luck with using it, so generally cheat and create a fast perl script to do it as normal inserts :( On Wed, 18 Aug 1999, Bruce Tong wrote: I feel

Re: [GENERAL] CVS Import/Export

1999-08-18 Thread Simon Drabble
On Wed, 18 Aug 1999, Bruce Tong wrote: I feel like such a bone-head asking this question, but I didn't find the answer in the FAQ or the documentation, other than pgaccess is supposed to have some of this functionality... How do I import/export comma delimited tables? I thought a

Re: [GENERAL] CVS Import/Export

1999-08-18 Thread Herouth Maoz
At 17:14 +0300 on 18/08/1999, Bruce Tong wrote: How do I import/export comma delimited tables? I thought a combination of pg_dump and psql might do it, but if so I must have missed it. I saw a mention of it for pgaccess, but I'm looking for something I can put in a shell script. It has

Re: [GENERAL] CVS Import/Export

1999-08-18 Thread Bruce Tong
There is a COPY command that you can use...there is a man page for it, sorry, don't use it myself, so dont know the syntax. Ahh, COPY. All I really needed was the pointer. I remember skimming that one and concluding it wasn't what I wanted. I must have skimmed too fast as I was certain it

Re: [GENERAL] CVS Import/Export

1999-08-18 Thread Stuart Rison
There is a COPY command that you can use...there is a man page for it, sorry, don't use it myself, so dont know the syntax. Then some bit about usually using Perl because of trouble getting COPY to perform exactly right and then having to pay the price with slow inserts instead of fast COPY