postgresql: copy help

[Chris Frost <chris@frostnet.advicom.net>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'd like to populate a database by entering the info via a text editor in
a tab/comma delimited file and import it into PostgreSQL using the copy
command, but I can't seem to get it working. I've tried slight variants of
"COPY weather FROM test.sql;" where weather is the class, and test.sql is
a test file in my current (home) directory that has the data comma
delimited.

thanks again,
Chris
<- Visit Me At <http://www.frostnet.advicom.net/chris/> ->

<------------------------------------------------------------------------------>
                               Public PGP Key:
     Email chris@frostnet.advicom.net with the subject "retrieve pgpkey" or
        visit <http://www.frostnet.advicom.net/chris/pgp_key.phtml>

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBNpqP7uEzIlbKpewXEQKBkgCgrn5H5vUCZ62Nh4Wen1uzYwHV3PMAn2KT
N7Y3yVcUmyfGCGWRTzEBivwY
=r9lX
-----END PGP SIGNATURE-----