Environment variables

Several environment variables can be used to customize the behaviour of the console tool (added to the general Libgda's environment variables):

  • Upon starting, if the GDA_SQL_CNC environment variable is defined, the console tool will try to open a connection using its contents as connection string.

  • The external editor used by the .e command is determined by the first value present in the GDA_SQL_EDITOR, EDITOR or VISUAL environment variables (in that order), and defaults to "vi" under Unix and "notepad.exe" under Windows.

  • The pager used when the data to display is more than one screen is determined by the value of the PAGER environment variable and defaults to "more" if none is defined. The paging feature can be completely disabled if the GDA_NO_PAGER is defined.

  • When the .graph is run, and if the GraphViz's dot is found, the console tool will convert the graph to a PNG file and display it using the external viewer identified by the contents of the GDA_SQL_VIEWER_PNG variable if defined (or convert it to a PDF and display it using the external viewer identified by the contents of the GDA_SQL_VIEWER_PDF variable if defined).

  • The command line history file is defined by the contents of the GDA_SQL_HISTFILE environment variable. If its contents is set to "NO_HISTORY" then no history will be kept.