author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Fri, 27 Jan 2017 22:47:14 +0200 | |
changeset 820 | 6ec465d43861 |
parent 630 | 85045711cebd |
permissions | -rw-r--r-- |
629
e7af6e868864
Set isql like prompt and go on semicolon.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
1 |
\set prompt="SQL> " |
e7af6e868864
Set isql like prompt and go on semicolon.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
diff
changeset
|
2 |
\set semicolon_hack=on |
630
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
3 |
|
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
4 |
\set date="%Y-%m-%d" |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
5 |
\set datetime="%Y-%m-%d %H:%M:%S" |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
6 |
|
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
7 |
# \set colwidth=20 |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
8 |
# \set style=pretty |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
9 |
# \set style=csv |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
10 |
# \set style=vert |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
11 |
# \set style=horiz |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
12 |
|
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
13 |
\set style=bcp |
85045711cebd
Set date format and output style.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
629
diff
changeset
|
14 |