-1

How can I get the values for the Vertica parameters

  • example :
    In oracle I can do this :
    sql:>show parameter <parameter_name>


How can I do this in vertica? And how to alter them?

chiwangc
  • 3,566
  • 16
  • 26
  • 32
Up_One
  • 5,213
  • 3
  • 33
  • 65

1 Answers1

1
SELECT * FROM CONFIGURATION_PARAMETERS;

You used to be able to do the following: select get_config_parameter('ParameterName');

I'm not sure if that is still available. There should also be a set_config_parameter function.

chiwangc
  • 3,566
  • 16
  • 26
  • 32
geoffrobinson
  • 1,580
  • 3
  • 15
  • 23
  • ok , i got it !! THX - yes i can use the get_cofig_parameter as well but i prefer creating a view of my own of the CONFIGURATION_PARAMETERS table and then play with it !! THX – Up_One Jul 19 '12 at 15:05