Hello Richard, The command you're after is COPY FROM and the full syntax is in the online docs at http://www.postgresql.org/docs/8.2/static/sql-copy.html That should get you started, at least. Pete On Tue, Apr 22, 2008 at 09:25:59AM +0100, beamends wrote: > Hi All, > I'm trying to get to grips with SQL (who knows, I may even produce > something worthwhile for the project!) only having some very basic > knowledge. I'm using phppgadmin for SQL type things. > > A weekly task is updating prices. So far I've got > > UPDATE parts > SET sellprice = 0.34, listprice = 0.34 > WHERE partnumber = '7316' > > which is fine, but how do I read a CSV file in? All the examples I've > found on the web seem to just "assume" that bit! > > Thanks in advance. > > Richard > > By the by, day one of going live with LSMB went well! > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Ledger-smb-users mailing list > ..hidden.. > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users -- Openstrike - improving business through open source http://www.openstrike.co.uk/ or call 01722 770036 / 07092 020107
Attachment:
pgp3l9BCsT71W.pgp
Description: PGP signature