=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%'