¾�ΥС�������ʸ�� �� 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9.6 | 9.5 | 9.4 | 9.3 | 9.2 | 9.1 | 9.0 | 8.4 | 8.3 | 8.2 | 8.1 | 8.0 | 7.4 | 7.3 | 7.2

COMMENT

Name

COMMENT  --  ���֥������ȤΥ����Ȥ�������ޤ��ϡ��ѹ����ޤ�

Synopsis

COMMENT ON
[
  [ DATABASE | INDEX | RULE | SEQUENCE | TABLE | TYPE | VIEW ] object_name |
  COLUMN table_name.column_name |
  AGGREGATE agg_name (agg_type) |
  FUNCTION func_name (arg1, arg2, ...) |
  OPERATOR op (leftoperand_type rightoperand_type) |
  TRIGGER trigger_name ON table_name
] IS 'text'

����

object_name, table_name,column_name, agg_name, func_name, op, trigger_name

�����Ȥ��դ��륪�֥������Ȥ�̾���Ǥ���

text

�ɲä��륳���ȤǤ���

����

COMMENT

�ơ��֥�Υ������դ����������������֤�����å������Ǥ���

����

COMMENT�ϡ��ǡ����١������֥������Ȥ˴ؤ��륳���Ȥ���¸���ޤ��������Ȥϡ� psql��\dd�� \d+��\l+ �ʤɤǴ�ñ�˼��������Ȥ��Ǥ��ޤ���obj_description() �� col_description() �Ȥ���̾���Ρ�psql �����Ѥ��Ƥ����Ȥ߹��ߴؿ�����Ѥ���褦�˹��ۤ��뤳�Ȥǡ�¾�Υ桼�����󥿥ե������ǥ����Ȥ���Ф����Ȥ��Ǥ��ޤ���

�����Ȥ��Խ�����ˤϡ�Ʊ�쥪�֥������Ȥ��Ф��ƿ����� COMMENT ���ޥ�ɤ�ȯ�Ԥ��ޤ����ƥ��֥������Ȥ���¸����륳����ʸ����� 1 �Ĥ����Ǥ��������Ȥ�������ˤϡ� NULL ��ƥ�����ʸ�������ʬ�˽񤭤ޤ������֥������Ȥ�������줿���������Ȥϼ�ưŪ�˺������ޤ���

���ߡ������Ȥ˥������ƥ�������¸�ߤ��ʤ����Ȥˤ����դ��ʤ���Фʤ�ޤ��󡣥ǡ����١�������³�����桼����ï�Ǥ⡢���Υǡ����١�����Υ��֥������ȤΥ����Ȥ򻲾Ȥ��뤳�Ȥ��Ǥ��ޤ�(�������������ѡ��桼���Τߤ���ͭ���Ƥ��ʤ����֥������Ȥ˴ؤ��륳���Ȥ��ѹ����뤳�Ȥ��Ǥ��ޤ�)�����Τ��ᡢ�������ƥ�Ū����̿Ū�ʾ���򥳥��Ȥ˵��ܤ��ƤϤ����ޤ���

������ˡ

mytable �ơ��֥�˥����Ȥ��դ��ޤ���

COMMENT ON mytable IS 'This is my table.';

�����Ĥ�¾����򼨤��ޤ���

COMMENT ON DATABASE my_database IS 'Development Database';
COMMENT ON INDEX my_index IS 'Enforces uniqueness on employee id';
COMMENT ON RULE my_rule IS 'Logs UPDATES of employee records';
COMMENT ON SEQUENCE my_sequence IS 'Used to generate primary keys';
COMMENT ON TABLE my_table IS 'Employee Information';
COMMENT ON TYPE my_type IS 'Complex Number support';
COMMENT ON VIEW my_view IS 'View of departmental costs';
COMMENT ON COLUMN my_table.my_field IS 'Employee ID number';
COMMENT ON AGGREGATE my_aggregate (double precision) IS 'Computes sample variance';
COMMENT ON FUNCTION my_function (timestamp) IS 'Returns Roman Numeral';
COMMENT ON OPERATOR ^ (text, text) IS 'Performs intersection of two text';
COMMENT ON TRIGGER my_trigger ON my_table IS 'Used for R.I.';

�ߴ���

SQL92

SQL92 �ˤ� COMMENT �Ϥ���ޤ���