
Hi, I am a linux hobbyist. I have been using postgis for a while, at a hobby level, to provide data for web pages and for QGIS. I am reasonably confident writing sql statements, and being able to find the information I need to get the data I am after. There are two areas I have been unable to find information on: * Writing sql / script files * Structuring tables either within a database, or on a server The particular problems I have are: * I regularly update my tables from multiple csv files, all residing in the same folder. Currently I have a script with a hardwired path for each csv file. I would like to have a single 'variable' I could change to define the path to all the csvs. * I have a database which I have decided should contain three types of table - core definitions / lookups, - raw data and - derived data for specific tasks. I would like to create separate areas in the database / (server?) for each table type, or learn of other options for how the tables could be structured. I am NOT looking for specific answers to these problems, but rather some teaching / groundwork information about relational databases / sql / postgis concepts. I have seen training videos / websites covering writing queries and on database security, but cannot find anything on script files, or database structure. I suspect wrong terminology and poor google skills are to blame. Can anyone suggest web sites etc that provide information on either / both of these two topics? With thanks Hugh