PostgreSQL Source Code  git master
settings.h
Go to the documentation of this file.
1 /*
2  * psql - the PostgreSQL interactive terminal
3  *
4  * Copyright (c) 2000-2023, PostgreSQL Global Development Group
5  *
6  * src/bin/psql/settings.h
7  */
8 #ifndef SETTINGS_H
9 #define SETTINGS_H
10 
11 #include "fe_utils/print.h"
12 #include "variables.h"
13 
14 #define DEFAULT_CSV_FIELD_SEP ','
15 #define DEFAULT_FIELD_SEP "|"
16 #define DEFAULT_RECORD_SEP "\n"
17 
18 #if defined(WIN32) || defined(__CYGWIN__)
19 #define DEFAULT_EDITOR "notepad.exe"
20 /* no DEFAULT_EDITOR_LINENUMBER_ARG for Notepad */
21 #else
22 #define DEFAULT_EDITOR "vi"
23 #define DEFAULT_EDITOR_LINENUMBER_ARG "+"
24 #endif
25 
26 #define DEFAULT_PROMPT1 "%/%R%x%# "
27 #define DEFAULT_PROMPT2 "%/%R%x%# "
28 #define DEFAULT_PROMPT3 ">> "
29 
30 /*
31  * Note: these enums should generally be chosen so that zero corresponds
32  * to the default behavior.
33  */
34 
35 typedef enum
36 {
42 
43 typedef enum
44 {
49 
50 typedef enum
51 {
56 
57 typedef enum
58 {
64 
65 typedef enum
66 {
67  hctl_none = 0,
72 
74 {
77  TRI_YES
78 };
79 
80 typedef struct _psqlSettings
81 {
82  PGconn *db; /* connection to backend */
83  int encoding; /* client_encoding */
84  FILE *queryFout; /* where to send the query results */
85  bool queryFoutPipe; /* queryFout is from a popen() */
86 
87  FILE *copyStream; /* Stream to read/write for \copy command */
88 
89  PGresult *last_error_result; /* most recent error result, if any */
90 
91  printQueryOpt popt; /* The active print format settings */
92 
93  char *gfname; /* one-shot file output argument for \g */
94  printQueryOpt *gsavepopt; /* if not null, saved print format settings */
95 
96  char *gset_prefix; /* one-shot prefix argument for \gset */
97  bool gdesc_flag; /* one-shot request to describe query result */
98  bool gexec_flag; /* one-shot request to execute query result */
99  bool bind_flag; /* one-shot request to use extended query protocol */
100  int bind_nparams; /* number of parameters */
101  char **bind_params; /* parameters for extended query protocol call */
102  bool crosstab_flag; /* one-shot request to crosstab result */
103  char *ctv_args[4]; /* \crosstabview arguments */
104 
105  bool notty; /* stdin or stdout is not a tty (as determined
106  * on startup) */
107  enum trivalue getPassword; /* prompt the user for a username and password */
108  FILE *cur_cmd_source; /* describe the status of the current main
109  * loop */
111  int sversion; /* backend server version */
112  const char *progname; /* in case you renamed psql */
113  char *inputfile; /* file being currently processed, if any */
114  uint64 lineno; /* also for error reporting */
115  uint64 stmt_lineno; /* line number inside the current statement */
116 
117  bool timing; /* enable timing of all queries */
118 
119  FILE *logfile; /* session log file handle */
120 
121  VariableSpace vars; /* "shell variable" repository */
122 
123  /*
124  * If we get a connection failure, the now-unusable PGconn is stashed here
125  * until we can successfully reconnect. Never attempt to do anything with
126  * this PGconn except extract parameters for a \connect attempt.
127  */
128  PGconn *dead_conn; /* previous connection to backend */
129 
130  /*
131  * The remaining fields are set by assign hooks associated with entries in
132  * "vars". They should not be set directly except by those hook
133  * functions.
134  */
137  bool quiet;
143  int histsize;
150  const char *prompt1;
151  const char *prompt2;
152  const char *prompt3;
153  PGVerbosity verbosity; /* current error verbosity level */
155  PGContextVisibility show_context; /* current context display level */
157 
158 extern PsqlSettings pset;
159 
160 
161 #ifndef EXIT_SUCCESS
162 #define EXIT_SUCCESS 0
163 #endif
164 
165 #ifndef EXIT_FAILURE
166 #define EXIT_FAILURE 1
167 #endif
168 
169 #define EXIT_BADCONN 2
170 
171 #define EXIT_USER 3
172 
173 #endif
PGContextVisibility
Definition: libpq-fe.h:134
PGVerbosity
Definition: libpq-fe.h:126
PSQL_ERROR_ROLLBACK
Definition: settings.h:51
@ PSQL_ERROR_ROLLBACK_INTERACTIVE
Definition: settings.h:53
@ PSQL_ERROR_ROLLBACK_ON
Definition: settings.h:54
@ PSQL_ERROR_ROLLBACK_OFF
Definition: settings.h:52
HistControl
Definition: settings.h:66
@ hctl_ignoredups
Definition: settings.h:69
@ hctl_ignoreboth
Definition: settings.h:70
@ hctl_none
Definition: settings.h:67
@ hctl_ignorespace
Definition: settings.h:68
PSQL_ECHO
Definition: settings.h:36
@ PSQL_ECHO_ALL
Definition: settings.h:40
@ PSQL_ECHO_ERRORS
Definition: settings.h:39
@ PSQL_ECHO_NONE
Definition: settings.h:37
@ PSQL_ECHO_QUERIES
Definition: settings.h:38
struct _psqlSettings PsqlSettings
PSQL_ECHO_HIDDEN
Definition: settings.h:44
@ PSQL_ECHO_HIDDEN_NOEXEC
Definition: settings.h:47
@ PSQL_ECHO_HIDDEN_OFF
Definition: settings.h:45
@ PSQL_ECHO_HIDDEN_ON
Definition: settings.h:46
@ TRI_YES
Definition: settings.h:77
@ TRI_DEFAULT
Definition: settings.h:75
@ TRI_NO
Definition: settings.h:76
PsqlSettings pset
Definition: startup.c:32
PSQL_COMP_CASE
Definition: settings.h:58
@ PSQL_COMP_CASE_PRESERVE_LOWER
Definition: settings.h:60
@ PSQL_COMP_CASE_LOWER
Definition: settings.h:62
@ PSQL_COMP_CASE_PRESERVE_UPPER
Definition: settings.h:59
@ PSQL_COMP_CASE_UPPER
Definition: settings.h:61
uint64 lineno
Definition: settings.h:114
printQueryOpt popt
Definition: settings.h:91
bool bind_flag
Definition: settings.h:99
char * gset_prefix
Definition: settings.h:96
PSQL_ERROR_ROLLBACK on_error_rollback
Definition: settings.h:147
bool hide_tableam
Definition: settings.h:141
VariableSpace vars
Definition: settings.h:121
PSQL_COMP_CASE comp_case
Definition: settings.h:148
int encoding
Definition: settings.h:83
char * inputfile
Definition: settings.h:113
PGVerbosity verbosity
Definition: settings.h:153
bool hide_compression
Definition: settings.h:140
FILE * logfile
Definition: settings.h:119
bool on_error_stop
Definition: settings.h:136
PGconn * dead_conn
Definition: settings.h:128
bool autocommit
Definition: settings.h:135
char * ctv_args[4]
Definition: settings.h:103
PGresult * last_error_result
Definition: settings.h:89
bool show_all_results
Definition: settings.h:154
const char * prompt2
Definition: settings.h:151
const char * prompt3
Definition: settings.h:152
FILE * copyStream
Definition: settings.h:87
char ** bind_params
Definition: settings.h:101
PGconn * db
Definition: settings.h:82
FILE * queryFout
Definition: settings.h:84
bool queryFoutPipe
Definition: settings.h:85
PSQL_ECHO echo
Definition: settings.h:145
bool singlestep
Definition: settings.h:139
enum trivalue getPassword
Definition: settings.h:107
uint64 stmt_lineno
Definition: settings.h:115
bool singleline
Definition: settings.h:138
PGContextVisibility show_context
Definition: settings.h:155
const char * prompt1
Definition: settings.h:150
PSQL_ECHO_HIDDEN echo_hidden
Definition: settings.h:146
printQueryOpt * gsavepopt
Definition: settings.h:94
char * gfname
Definition: settings.h:93
int fetch_count
Definition: settings.h:142
bool cur_cmd_interactive
Definition: settings.h:110
bool gexec_flag
Definition: settings.h:98
bool crosstab_flag
Definition: settings.h:102
FILE * cur_cmd_source
Definition: settings.h:108
HistControl histcontrol
Definition: settings.h:149
const char * progname
Definition: settings.h:112
bool gdesc_flag
Definition: settings.h:97
int bind_nparams
Definition: settings.h:100
trivalue
Definition: vacuumlo.c:35