Could you please tell me what's the syntax with INSERT for this?
On 1/5/06, Bruno Wolff III <bruno@wolff.to> wrote: On Thu, Jan 05, 2006 at 22:51:55 -0600,
Angshu Kar < angshu96@gmail.com> wrote:
> Hi Pgsql,
>
> I've a table schema in pg say as:
>
> (A B C D E)
>
> where none of these fields allow null.
>
> Now, I've a flat file that has got tab-delimited data for B,C and E fields.
> And A,B come from sequences.
>
> Could anyone please let me know how I can upload the complete dataset into
> the table?
Use COPY or INSERT with explicitly named columns. (I think this is a
relatively new feature for COPY, but you can use it for INSERT in any version.)
--
Ignore the impossible but honor it ...
The only enviable second position is success, since failure always comes first...