Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!know!zaphod.mps.ohio-state.edu!sdd.hp.com!decwrl!shelby!portia.stanford.edu!chesky
From: chesky@portia.Stanford.EDU (Snehylata Gupta)
Newsgroups: comp.databases
Subject: Re: Need help with INGRES SQL copy to/from file
Message-ID: <1990Aug28.211814.7355@portia.Stanford.EDU>
Date: 28 Aug 90 21:18:14 GMT
References: <11104@spool.cs.wisc.edu>
Organization: AIR, Stanford University
Lines: 33

In article <11104@spool.cs.wisc.edu> beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) writes:
>
>  Iam trying to transfer the contents of one table to another
>  using "copy from" and "copy into".
>
>  The SQL statement:
>
>	copy table atomlook3 (atomnumb=c0,comma=d1,
>						  aaname=c0,comma=d1,
>						  atomname=c0, comma=d1,
>						  nucleus = c0)
>   into 'DSK$USER12:[NMRDB]pd.out'
>
>
>results in a nicely formatted file with one line for
>each record in the table atomlook3. If I then try to 
>transfer the file's contents  
>into a new table:
>
>	 copy table pd_atom_look(atomnumb=c0comma,
>							 aaname=c0comma,
>							 atomname=c0comma,
>							 nucleus=c0)
                                                                   ^
  Should be c0nl.
  From the syntax of copying into the file. You have to tell Ingres to
read a newline character as the delimiter after reading the column nucleus.

>Just what syntax exactly does Ingres/SQL want here?

I hope that is what Ingres wants.

Sanjay