Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

sqlformat(1) [debian man page]

SQLFORMAT(1)							   User Commands						      SQLFORMAT(1)

sqlformat - reformat SQL SYNOPSIS
sqlformat [ OPTION ] ... [ FILE ] ... DESCRIPTION
The `sqlformat' command-line tool can be used to reformat SQL file according to specified options or prepare a snippet in in some program- ming language (only Python and PHP currently supported). Use "-" for FILE to read from stdin. OPTIONS
-i CHOICE|--identifiers=FORMAT Change case of identifiers. FORMAT is one of "upper", "lower", "capitalize". -k CHOICE|--keywords=FORMAT Change case of keywords. FORMAT is one of "upper", "lower", "capitalize". -l CHOICE|--language=LANG Output a snippet in programming language LANG. LANG can be "python", "php". -o FILE|--outfile=FILE Write output to FILE (defaults to stdout). -r|--reindent Reindent statements. --indent_width=INDENT_WIDTH Set indent width to INDENT_WIDTH. Default is 2 spaces. --strip-comments Remove comments. -h|--help Print a short help message and exit. All subsequent options are ignored. --verbose Verbose output. --version Print program's version number and exit. AUTHORS
This man page was written by Andriy Senkovych <> python-sqlparse version: 0.1.2 December 2010 SQLFORMAT(1)

Check Out this Related Man Page

gnubg(6)																  gnubg(6)

gnubg - GNU Backgammon program SYNOPSIS
gnubg -bcdlpqrStvw [file.sgf] DESCRIPTIONS
GNU Backgammon gnubg (6) plays and analyzes backgammon games and matches. It is able to play and analyze both money games and tournament matches, evaluate and roll out positions, and more. OPTIONS
-b, --no-bearoff Do not use bearoff database -c, --commands=FILE Evaluate commands in FILE and exit -d, --datadir=DIR Read database and weight files from DIR -l, --lang=LANG Set language to LANG -p, --python=FILE Evaluate Python code in FILE and exit -q, --quiet Disable sound effects -r, --no-rc Do not read .gnubgrc and .gnubgautorc commands -S, --splash Show gtk splash screen -t, --tty Start on tty instead of using window system -v, --version Show version information and exit -w, --window-system-only Ignore tty input when using window system FILES
~/.gnubg/gnubgautorc, ~/.gnubg/gnubg.db, ~/.gnubg/gnubg.gtkrc AUTHORS
Joseph Heled, Oystein Johansen, Jorn Thyssen, and Gary Wong, with the assistance of many others. Bug reports go to <>. Manual written by Christian Anthon 26 August 2014 gnubg(6)
Man Page

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

what is python?

I heard that its a new programming language but ill like to get a deeper explaination of it. (1 Reply)
Discussion started by: kprescod4158
1 Replies

2. UNIX for Dummies Questions & Answers

Reformatting file

Hi, How can I reformat a file (text file) using unix command. This file was FTP'd from Mainframe and contains some garbage character at the end of each line. Each line contains special characters '<soh>' at the end which should have been spaces when I view it in emacs or nedit. I couldnt do find... (2 Replies)
Discussion started by: mrjunsy
2 Replies

3. Shell Programming and Scripting

Zenity Menu

I have some troubles with zenity and menu. I seach for: MAIN MENU CHOICE 1 "do something" CHOICE 2 "do something 2" CHOICE 3 "do something 3" But then in "do someghing " when i click i want to return to the MAIN MENU So something like: while true; do ... (4 Replies)
Discussion started by: aspire
4 Replies

4. Programming

Which language is best suited for regular expressions perl,python.ruby ?

Hello all, i am in a bit of dilema here. i dont know any thing about perl or python. only know a little bit of awk. now unable to take a decission as to which language to go for. my requirement is building a testing framework.suite which will execute ssytem comands remotely on unix... (2 Replies)
Discussion started by: achak01
2 Replies

5. Programming

What programming language would I use to make a translating program?

I want to create a computer program that will translate from English to Spanish and vice versa. So someone could type in a word, phrase, or paragraph and translate from one language to another. What programming language would I use to write up the code and then implement this program? I want to... (0 Replies)
Discussion started by: Anna Hussie
0 Replies

6. Shell Programming and Scripting

How to search for right word using awk?

Hi- I have issue with the code to get the input file reformat --Goal is reformat and print out only column name one per line, leading space or trailing space will be removed... --TABLE1.DDL as input file, and content of file as show below REPLACE VIEW TABLE1 ( ID ,COL1 ... (3 Replies)
Discussion started by: lv99
3 Replies

7. Shell Programming and Scripting

[Solved] File reformat

I am using the code below to reformat the input (hp.txt). The output (newhp.txt) is not in the desired format and I can not seem to figure it out. I have attached both. Thank you. perl -aF/\\t/ -lne 'print join(" ",@F) for ("0 A","0 G","0 C","0 T","A 0","G 0","C 0","T 0")' hp.txt > newhp.txt ... (4 Replies)
Discussion started by: cmccabe
4 Replies

8. Programming

Curious About Offbeat "#" Usage in C . . .

Greetings! Being incredibly rusty in the little C which I ever knew, and, not knowing where else to turn but the best programming community on the web ( :) ), I submit the following snippet for a quick question:#if PERL_VERSION > 7 if (DEBUG_D_TEST) { SV* sva; ... (3 Replies)
Discussion started by: LinQ
3 Replies

9. Programming

Python Regex List Creation

Here is a snippet of my code: blahblahblah... blah for link in goodies.soup.find_all('a'): blah.append(link.get('href')) blah=list(set(blah)) which gives my list of urls. So now I use a regex to search for the relevant urls which I want in a list: for r... (0 Replies)
Discussion started by: metallica1973
0 Replies

10. Shell Programming and Scripting

Change in the file

Hi, I have a file which has wrong time format and we want to correct it before we load it. WRONG FORMAT : 93:0:00 CORRECT FORMAT :09:30:00 If you notice the 0 at the front is missing. Its the case always. (6 Replies)
Discussion started by: varun22486
6 Replies

Featured Tech Videos