On Tue, 2008-04-22 at 09:40 +0100, Pete Houston wrote: > 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
Thanks for that. Cheers Richard > > 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 > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------- > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
