| From: | Charles Tassell <ctassell(at)isn(dot)net> |
|---|---|
| To: | Vadim Mikheev <vadim(at)krs(dot)ru> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] COPY with default values won't work? |
| Date: | 1999-03-24 05:48:22 |
| Message-ID: | 4.1.19990324014400.00b105d0@mailer.isn.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
@#$#!! Any way to make COPY use default, or shove a lot of data in with a
single INSERT query? According to older messages in the mailing list, it
is *possible*, but I can't get it to work.
My problem is that I might be using this to put a few thousand entries in
the db every night, and when I last attempted this using a few thousand
insert statements, it was awfully slow (on the order of taking HOURS)
BTW: Thanks for the quick response. I send the mail, answer some messages,
and get a response. Quicker than a Microsoft $0.95/min help line. :-)
At 01:24 AM 3/24/99, you wrote:
>This is standard behaviour. DEFAULT is for INSERT only,
>when attribute is not specified in INSERT' target list.
>
>Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vadim Mikheev | 1999-03-24 07:31:14 | Re: [GENERAL] COPY with default values won't work? |
| Previous Message | Vadim Mikheev | 1999-03-24 05:24:22 | Re: [GENERAL] COPY with default values won't work? |