IO::Adapter supports PostgreSQL

1 files changed, 106 insertions, 0 deletions

diff --git a/fml/etc/src/config.cf.ja/postgresql.cf b/fml/etc/src/config.cf.ja/postgresql.cf
new file mode 100644
index 00000000..9a6fbf7d
--- /dev/null
+++ b/fml/etc/src/config.cf.ja/postgresql.cf
@@ -0,0 +1,106 @@
+=head1 PostgreSQL の例
+
+
+#
+# 注意: 次の ^=head で名前空間はリセットされる
+#
+# [Example]
+# create table ml (
+# 	fml_ml        char(64),
+# 	fml_address   char(64),
+# 	fml_member    int,
+# 	fml_recipient int
+# );
+
+
+[postgresql:fml]
+
+
+# Descriptions:
+#      History:
+#        Value: HOSTNAME
+#     Examples:
+sql_servers	=	localhost
+
+
+# Descriptions:
+#      History:
+#        Value: USER
+#     Examples:
+sql_user	=	fml
+
+
+# Descriptions:
+#      History:
+#        Value: PASSWORD
+#     Examples:
+sql_password	=	uja
+
+
+# Descriptions:
+#      History:
+#        Value: SQL_DATABASE
+#     Examples:
+sql_database	=	fml
+
+
+# Descriptions:
+#      History:
+#        Value: SQL_TABLE
+#     Examples:
+sql_table	=	ml
+
+
+# Descriptions: 注意: 各行を取り出すのではなく
+#		とりあえず全て取りだしキャッシュするクエリ
+#      History:
+#        Value: SQL_QUERY_STATEMENT
+#     Examples:
+sql_query_get_next_key =	select fml_address from $sql_table
+				where fml_ml = '$ml_name'
+					and
+				fml_domain = '$ml_domain'
+
+
+# Descriptions: 注意: 各行を取り出すのではなく
+#		とりあえず全て取りだしキャッシュするクエリ
+#      History:
+#        Value: SQL_QUERY_STATEMENT
+#     Examples:
+sql_query_getline	=	select fml_address from $sql_table
+				where fml_ml = '$ml_name'
+					and
+				fml_domain = '$ml_domain'
+
+
+# Descriptions:
+#      History:
+#        Value: SQL_QUERY_STATEMENT
+#     Examples:
+sql_query_add	=	insert into $sql_table
+			values ('$ml_name', '$ml_domain', '&address', 1, 1)
+
+
+# Descriptions:
+#      History:
+#        Value: SQL_QUERY_STATEMENT
+#     Examples:
+sql_query_delete	=	delete from $sql_table
+				where	fml_ml = '$ml_name'
+					and
+				fml_domain = '$ml_domain'
+					and
+				fml_address = '&address'
+
+
+# Descriptions: 注意: 各行を取り出すのではなく
+#		とりあえず全て取りだしキャッシュするクエリ
+#      History:
+#        Value: SQL_QUERY_STATEMENT
+#     Examples:
+sql_query_find		=	select fml_address from $sql_table
+				where	fml_ml = '$ml_name'
+					and
+				fml_domain = '$ml_domain'
+					and
+				fml_address like '%&regexp%'