On Wed, Sep 27, 2000 at 05:11:37PM +0300, Martin Kuria wrote: > I have entered my data in and excel spreadsheet file, now I would like > to populate this data in my postgresql database, I have tried to use > COPY command to populate the data to my postgresql database but still > it does not work what should do or use??
You did export that Excel spreadsheet into a text file using some kind of delimiter that *won't* exist in your data? template1=# copy my_data from stdin using delimiters '|'; >> b|Loxodromic >> c|Philanders >> d|Insomniacs >> \. If you're copying from a file, put the full path to the file in single quotes like: template1=# copy my_data from '/home/mkuria/my_data.dat' using delimiters '|'; Okay? (You only need the "\." on the last line if you're redirecting from Standard Input (stdin).) -- /bin/sh ~/.signature: Command not found
