-
Notifications
You must be signed in to change notification settings - Fork 4
/
.pg_format
65 lines (65 loc) · 2.53 KB
/
.pg_format
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
####
# From: https://github.com/darold/pgFormatter/blob/master/doc/pg_format.conf.sample
####
keep-newline=1
# NOTE: Not in default config, required to have multiple input files
inplace=1
# Obscure all literals in queries, use to hide confidential data before formatting.
anonymize=0
# In a parameters list, end or start with the comma. Default: end
comma=start
# In insert statement, add a newline after each comma.
comma-break=0
# Output format: text or html. Default: text.
format=text
# Add a newline between statements in transaction regroupement. Default is to group statements.
nogrouping=1
# Change the case of the reserved keyword. Default is uppercase: 2.
# Values: 0=>unchanged, 1=>lowercase, 2=>uppercase, 3=>capitalize.
keyword-case=1
# Change the case of the data type name. Default is lowercase: 1.
# Values: 0=>unchanged, 1=>lowercase, 2=>uppercase, 3=>capitalize.
type-case=1
# Change the case of the PostgreSQL functions. Default is unchanged: 0.
# Values: 0=>unchanged, 1=>lowercase, 2=>uppercase, 3=>capitalize.
function-case=2
# Do not add an extra empty line at end of the output.
no-extra-line=0
# Maximum length of a query, it will be cutted above the given size. Default: no truncate.
maxlength=0
# Remove any comment from SQL code.
nocomment=0
# Statement numbering as a comment before each query.
numbering=0
# Define the filename for the output. Default: stdout.
output=
# Set regex to find code that must not be changed.
# NOTE: Single escaping and remove quotes!
placeholder=sqlc\.(arg|narg)\(:?[^)]*\)
# Use multi-line search for placeholder regex.
multiline=0
# Add RedShift keyworks to the list of SQL keyworks.
# (obsolete use extra-keyword=redshift instead)
redshift=0
# Dynamic code separator, default to single quote.
separator=
# Change space indent, default 4 spaces.
spaces=2
# Try another formatting type for some statements.
format-type=0
# Use tabs instead of space characters, when used spaces is set to 1 whatever is its value.
tabs=0
# Wrap queries at a certain length.
wrap-limit=130
# Number of column after which lists must be wrapped.
wrap-after=0
# with --wrap-limit, apply reformatting to comments.
wrap-comment=0
# Add a list of function to be formatted as PG internal functions.
#extra-function=/opt/pgFormatter/functions.lst
# Add a list of keywords to be formatted as PG internal keywords.
# Special value redshift mean use internal defined redshift keywords.
#extra-keyword=/opt/pgFormatter/epas.kw
# Remove the space character between a function call and the open parenthesis that follow.
# unknown option
# no-space-function=0