Re: Getting started with Postgres
Never expected to start a flame-war over this.
I need visual tools to set the stuff up and run it and they are not evident.
Actually, the OpenOffice database is not at all bad (except that it imports
empty spreadsheet items as blanks (NOT EMPTY, NOT NULL). It can be readilly
queried, reports generated and executes SQL. Maybe I can even create the two
tables using SQL right there (the GUI has new tables disabled because of the
linkage below, I suppose).
The database is LINKED to the spreadsheet. In other words, change the
spreadsheet and the database content has also changed along with querie
results and report contents. This is cool.
[The main snafu I see is because it accepts both its own and SQL syntax in
line, LIKE '%*' (find content ending with *) will not work. The resultant SQL
will be LIKE "%%". Excaping the * does not help. Entering it is the SQL edit
views does not help--same thing happens :-)]