Re: [SQL] Running a file

2000-12-24 Thread Brett W. McCoy
On Sun, 24 Dec 2000, Thomas SMETS wrote: > I'm runnin postgres 7.?? (Last RPM package available from the site). > > I want to create a few DB creation scripts so I can "publish" that > afterwards. > On Oracle there's a such possibility but I haven't seen anything > comaprable in the docs ... > I

Re: [SQL] Invoice number

2000-12-24 Thread D'Arcy J.M. Cain
Thus spake Oliver Elphick > >If so, why is no rollbackable an issue? All you should need is unique > >numbers. Not necessarily exactly sequential numbers. > > For invoice numbers, it matters. > > Numbers missing from such a sequence are likely to provoke questions from > auditors and taxme

[ADMIN] Running a file

2000-12-24 Thread Raju Mathur
Hi Thomas, Is it possible you're looking for: psql -f script.sql ? Regards, -- Raju > "Thomas" == Thomas SMETS <[EMAIL PROTECTED]> writes: Thomas> I'm runnin postgres 7.?? (Last RPM package available from Thomas> the site). Thomas> I want to create a few DB creation scr

[SQL] Running a file

2000-12-24 Thread Thomas SMETS
I'm runnin postgres 7.?? (Last RPM package available from the site). I want to create a few DB creation scripts so I can "publish" that afterwards. On Oracle there's a such possibility but I haven't seen anything comaprable in the docs ... I however think I'm missing one of the very first pos