vertica增加中文字段注释和中文表名注释

迷南。 2022-05-15 04:41 693阅读 0赞

vertica增加中文字段注释

  1. -- Note:Column comments are on the projection columns.
  2. -- eg.
  3. --   dbadmin=> comment on column public.test1.col1 is 'day';
  4. --   ROLLBACK 2639:  Column "test1"."col1" does not exist as a projection column
  6. -- step1:Get table's projection name
  7. select min(projection_schema||'.'||projection_name) projection_name 
  8.   from projections 
  9.  where projection_schema = 'public' and anchor_table_name = 'test1'
  10. ;
  12. -- step2:Comment on projection column 
  13. comment on column public.test1_super.col1 is 'day';
  15. -- check
  16. select comment from comments where object_name = 'test1_super.col1';
  19. -- Examples
  20. dbadmin=> select min(projection_schema||'.'||projection_name) projection_name from projections where projection_schema = 'public' and anchor_table_name = 'test1';
  21. dbadmin-> ;
  22.   projection_name   
  23. --------------------
  24.  public.test1_super
  25. (1 row)
  27. dbadmin=> \d test1
  28.                                                 List of Fields by Tables
  29.  Schema | Table | Column |    Type     | Size |             Default              | Not Null | Primary Key | Foreign Key 
  30. --------+-------+--------+-------------+------+----------------------------------+----------+-------------+-------------
  31.  public | test1 | col1   | varchar(8)  |    8 | to_char("sysdate"(), 'yyyymmdd') | f | f | 
  32.  public | test1 | col2   | varchar(12) |   12 |                                  | f        | f           | 
  33.  public | test1 | col3   | int         |    8 |                                  | f        | f           | 
  34. (3 rows)
  36. dbadmin=> select comment from comments where object_name = 'test1_super.col1';
  37.  comment 
  38. ---------
  39. (0 rows)
  41. dbadmin=> comment on column public.test1.col1 is 'day';
  42. ROLLBACK 2639:  Column "test1"."col1" does not exist as a projection column
  44. dbadmin=> comment on column public.test1_super.col1 is 'day';
  45. COMMENT
  46. dbadmin=> select comment from comments where object_name = 'test1_super.col1';
  47.  comment 
  48. ---------
  49.  day
  50. (1 row)

vertica增加中文字段

  1. dbadmin=> comment on table public.test is '测试表';

发表评论

表情：
评论列表 （有 0 条评论，693人围观）

还没有评论，来说两句吧...

相关阅读

    相关 fastadmin 的表注释和字段注释

    在安装好 fastdamin 之后，看官方的文档，说是创建表的时候，要写表注释和字段注释； 不了解数据库，只知道简单的表和字段的概念，这个注释是什么还真的不了解，于是，学习一

    青旅半醒青旅半醒/ 0 赞/ 612 阅读