[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
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
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
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
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
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