|
From: Dieter S. <dsi...@sq...> - 2001-08-11 00:39:41
|
The README file in the doc section has the right info. schema scripts are in the sql directory. to setup the tables $ psql dbname < acc-Pg.sql Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sat, 11 Aug 2001, Noel Cordell wrote: > Hi, > > I think I have successfully installed sql ledger and required > components. > > In the readme under SETUP A DATABASE AND THE TABLES there is an > instruction to select the Database Administration link.. I don't see > that link. I created a user and filled in the relevant information, > dbname port etc, I manually created a database at the command line that > I referenced here. > > Regarding the tables in the database, do I need to create these manually > too, or does the script do this? > > Apologies if I am missing something obvious here. > > Thanks > > Noel Running Redhat Linux 7.0 > > P.S. Login works fine, but selecting links on the left results in > errors. There are no tables in the database to query, so this is > predictable I guess. > > eg > ERROR: Relation 'chart' does not exist SELECT accno, description FROM > chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY > accno > > > > > > > |