Changeset 10866

Timestamp:

2005-11-08T11:32:09+13:00 (18 years ago)

Author:

jrm21

Message:

gave examples for CSV files

File:

• trunk/gsdl/etc/packages/example.dbi (modified) (2 diffs)

trunk/gsdl/etc/packages/example.dbi

@@ -34 +34 @@
 # Eg, for postgres, it is "DBI:Pg:dbname=<database>".
 # For mysql, it might look like "DBI:mysql:database=<database>;host=localhost"
-# Case is important!
+# For the CSV (comma-separated values text-file) backend, try something like
+#   'DBI:CSV:f_dir=/path/to/file;csv_quote_char=\";csv_sep_char=    '
+# with an embedded tab character for tab-separated instead of the
+# default comma-separated.
+# Case may be important!
 #
 #$db='';
@@ -48 +52 @@
 #
 #$sql_query = 'SELECT id, name,  data FROM table1 JOIN table2 WHERE something';
+# For CSV, the table name is the file name. Eg:
+#$sql_query = 'SELECT * FROM values.txt'
+# CSV may also require DOS '\r\n'-style line endings instead of unix '\n'.