[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 l
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 wou
>> 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
maybe i'm doing something wrong here:
CREATE TABLE samples
(
mark abstime,
subnetinet,
bytes_in float8,
bytes_out float8
);
CREATE INDEX samples_mark ON samples (mark);
--- fill it with lots and lots of data
BEGIN WORK;
DECLARE mycurs CURSOR FOR
SELECT DATE_PART('epoch
> if i revert my code to (note: less the DATE_PART conversion):
>
> DECLARE mycurs CURSOR FOR
>SELECT mark, subnet, bytes_in, bytes_out
>FROM samples
>WHERE mark >= 'epoch or another date'::abstime;
>
> it works fine.
as a followup, if i use:
DECLARE mycurs CURSOR FOR
SELECT mar
>
> maybe i'm doing something wrong here:
>
> CREATE TABLE samples
> (
> mark abstime,
> subnetinet,
> bytes_in float8,
> bytes_out float8
> );
> CREATE INDEX samples_mark ON samples (mark);
>
> --- fill it with lots and lots of data
>
> BEGIN WORK;
> DECLARE mycurs CURSO
