On Sat, Aug 13, 2005 at 09:25:34AM -0600, Michael Fuhr wrote:
>
> Here's the list I came up with -- variables that SHOW shows that
> aren't in psql's completion list.

Here's the list broken down by context:

PGC_USERSET
  autocommit
  check_function_bodies
  debug_assertions
  escape_string_warning
  exit_on_error
  role
  session_authorization
  transaction_isolation
  transaction_read_only
  vacuum_cost_delay
  vacuum_cost_limit
  vacuum_cost_page_dirty
  vacuum_cost_page_hit
  vacuum_cost_page_miss

PGC_SUSET
  debug_deadlocks
  log_btree_build_stats
  trace_locks
  trace_lock_oidmin
  trace_lock_table
  trace_lwlocks
  trace_userlocks
  zero_damaged_pages

PGC_INTERNAL
  block_size
  integer_datetimes
  is_superuser
  lc_collate
  lc_ctype
  max_function_args
  max_identifier_length
  max_index_keys
  server_version
  standard_compliant_strings

PGC_POSTMASTER
  bonjour_name
  config_file
  custom_variable_classes
  data_directory
  external_pid_file
  hba_file
  ident_file
  krb_caseins_users
  krb_server_hostname
  krb_server_keyfile
  krb_srvname
  listen_addresses
  max_prepared_transactions
  preload_libraries
  redirect_stderr
  silent_mode

PGC_SIGHUP
  archive_command
  authentication_timeout
  autovacuum
  autovacuum_analyze_scale_factor
  autovacuum_analyze_threshold
  autovacuum_naptime
  autovacuum_vacuum_cost_delay
  autovacuum_vacuum_cost_limit
  autovacuum_vacuum_scale_factor
  autovacuum_vacuum_threshold
  bgwriter_all_maxpages
  bgwriter_all_percent
  bgwriter_delay
  bgwriter_lru_maxpages
  bgwriter_lru_percent
  checkpoint_segments
  checkpoint_timeout
  checkpoint_warning
  db_user_namespace
  full_page_writes
  log_directory
  log_filename
  log_hostname
  log_line_prefix
  log_rotation_age
  log_rotation_size
  log_truncate_on_rotation
  pre_auth_delay

PGC_BACKEND
  log_connections
  log_disconnections

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to