Re: Not Strictly LSMB but....

[beamends <..hidden..>]

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
> > ..hidden..
> > 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users