1 # SOME DESCRIPTIVE TITLE
2 # Copyright (C) YEAR Free Software Foundation, Inc.
3 # This file is distributed under the same license as the PACKAGE package.
4 # FIRST AUTHOR <EMAIL@ADDRESS>, YEAR.
9 "Project-Id-Version: PACKAGE VERSION\n"
10 "POT-Creation-Date: 2021-06-19 15:28+0900\n"
11 "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
12 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
13 "Language-Team: LANGUAGE <LL@li.org>\n"
16 "Content-Type: text/plain; charset=UTF-8\n"
17 "Content-Transfer-Encoding: 8bit\n"
20 #: original/man1/sqlite3.1:5
26 #: original/man1/sqlite3.1:5
28 msgid "Fri Oct 31 10:41:31 EDT 2014"
31 #. Please adjust this date whenever revising the manpage.
33 #. Some roff macros, for reference:
34 #. .nh disable hyphenation
35 #. .hy enable hyphenation
37 #. .ad b justify to both left and right margins
38 #. .nf disable filling
40 #. .br insert line break
41 #. .sp <n> insert n+1 empty lines
42 #. for manpage-specific macros, see man(7)
44 #: original/man1/sqlite3.1:18
50 #: original/man1/sqlite3.1:21
51 msgid "B<sqlite3> - A command line interface for SQLite version 3"
55 #: original/man1/sqlite3.1:22
61 #: original/man1/sqlite3.1:27
62 msgid "B<sqlite3> [I<options>] [I<databasefile>] [I<SQL>]"
66 #: original/man1/sqlite3.1:28
72 #: original/man1/sqlite3.1:36
74 "B<sqlite3> is a terminal-based front-end to the SQLite library that can "
75 "evaluate queries interactively and display the results in multiple formats. "
76 "B<sqlite3> can also be used within shell scripts and other applications to "
77 "provide batch processing features."
81 #: original/man1/sqlite3.1:37
87 #: original/man1/sqlite3.1:45
89 "To start a B<sqlite3> interactive session, invoke the B<sqlite3> command and "
90 "optionally provide the name of a database file. If the database file does "
91 "not exist, it will be created. If the database file does exist, it will be "
96 #: original/man1/sqlite3.1:48
98 "For example, to create a new database file named \"mydata.db\", create a "
99 "table named \"memos\" and insert a couple of records into that table:"
103 #: original/man1/sqlite3.1:51
104 msgid "$ B<sqlite3 mydata.db>"
108 #: original/man1/sqlite3.1:53
109 msgid "SQLite version 3.8.8"
113 #: original/man1/sqlite3.1:55
114 msgid "Enter \".help\" for instructions"
118 #: original/man1/sqlite3.1:58
119 msgid "sqliteE<gt> B<create table memos(text, priority INTEGER);>"
123 #: original/man1/sqlite3.1:61
124 msgid "sqliteE<gt> B<insert into memos values('deliver project description', 10);>"
128 #: original/man1/sqlite3.1:64
129 msgid "sqliteE<gt> B<insert into memos values('lunch with Christine', 100);>"
133 #: original/man1/sqlite3.1:67
134 msgid "sqliteE<gt> B<select * from memos;>"
138 #: original/man1/sqlite3.1:69
139 msgid "deliver project description|10"
143 #: original/man1/sqlite3.1:71
144 msgid "lunch with Christine|100"
148 #: original/man1/sqlite3.1:73
153 #: original/man1/sqlite3.1:80
155 "If no database name is supplied, the ATTACH sql command can be used to "
156 "attach to existing or create new database files. ATTACH can also be used to "
157 "attach to multiple databases within the same interactive session. This is "
158 "useful for migrating data between databases, possibly changing the schema "
163 #: original/man1/sqlite3.1:84
165 "Optionally, a SQL statement or set of SQL statements can be supplied as a "
166 "single argument. Multiple statements should be separated by semi-colons."
170 #: original/man1/sqlite3.1:86
175 #: original/man1/sqlite3.1:89
176 msgid "$ B<sqlite3 -line mydata.db 'select * from memos where priority E<gt> 20;'>"
180 #: original/man1/sqlite3.1:91
182 msgid " text = lunch with Christine\n"
186 #: original/man1/sqlite3.1:93
187 msgid "priority = 100"
191 #: original/man1/sqlite3.1:96
193 msgid "SQLITE META-COMMANDS"
197 #: original/man1/sqlite3.1:103
199 "The interactive interpreter offers a set of meta-commands that can be used "
200 "to control the output format, examine the currently attached database files, "
201 "or perform administrative operations upon the attached databases (such as "
202 "rebuilding indices). Meta-commands are always prefixed with a dot (.)."
206 #: original/man1/sqlite3.1:106
208 "A list of available meta-commands can be viewed at any time by issuing the "
209 "'.help' command. For example:"
213 #: original/man1/sqlite3.1:109
214 msgid "sqliteE<gt> B<.help>"
218 #: original/man1/sqlite3.1:170
221 "%backup ?DB? FILE Backup DB (default \"main\") to FILE\n"
222 "%bail on|off Stop after hitting an error. Default OFF\n"
223 "%clone NEWDB Clone data into NEWDB from the existing database\n"
224 "%databases List names and files of attached databases\n"
225 "%dump ?TABLE? ... Dump the database in an SQL text format\n"
226 " If TABLE specified, only dump tables matching\n"
227 " LIKE pattern TABLE.\n"
228 "%echo on|off Turn command echo on or off\n"
229 "%eqp on|off Enable or disable automatic EXPLAIN QUERY PLAN\n"
230 "%exit Exit this program\n"
231 "%explain ?on|off? Turn output mode suitable for EXPLAIN on or off.\n"
232 " With no args, it turns EXPLAIN on.\n"
233 "%fullschema Show schema and the content of sqlite_stat tables\n"
234 "%headers on|off Turn display of headers on or off\n"
235 "%help Show this message\n"
236 "%import FILE TABLE Import data from FILE into TABLE\n"
237 "%indices ?TABLE? Show names of all indices\n"
238 " If TABLE specified, only show indices for tables\n"
239 " matching LIKE pattern TABLE.\n"
240 "%load FILE ?ENTRY? Load an extension library\n"
241 "%log FILE|off Turn logging on or off. FILE can be stderr/stdout\n"
242 "%mode MODE ?TABLE? Set output mode where MODE is one of:\n"
243 " csv Comma-separated values\n"
244 " column Left-aligned columns. (See .width)\n"
245 " html HTML E<lt>tableE<gt> code\n"
246 " insert SQL insert statements for TABLE\n"
247 " line One value per line\n"
248 " list Values delimited by .separator string\n"
249 " tabs Tab-separated values\n"
250 " tcl TCL list elements\n"
251 "%nullvalue STRING Use STRING in place of NULL values\n"
252 "%once FILENAME Output for the next SQL command only to FILENAME\n"
253 "%open ?FILENAME? Close existing database and reopen FILENAME\n"
254 "%output ?FILENAME? Send output to FILENAME or stdout\n"
255 "%print STRING... Print literal STRING\n"
256 "%prompt MAIN CONTINUE Replace the standard prompts\n"
257 "%quit Exit this program\n"
258 "%read FILENAME Execute SQL in FILENAME\n"
259 "%restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
260 "%save FILE Write in-memory database into FILE\n"
261 "%schema ?TABLE? Show the CREATE statements\n"
262 " If TABLE specified, only show tables matching\n"
263 " LIKE pattern TABLE.\n"
264 "%separator STRING ?NL? Change separator used by output mode and .import\n"
265 " NL is the end-of-line mark for CSV\n"
266 "%shell CMD ARGS... Run CMD ARGS... in a system shell\n"
267 "%show Show the current values for various settings\n"
268 "%stats on|off Turn stats on or off\n"
269 "%system CMD ARGS... Run CMD ARGS... in a system shell\n"
270 "%tables ?TABLE? List names of tables\n"
271 " If TABLE specified, only list tables matching\n"
272 " LIKE pattern TABLE.\n"
273 "%timeout MS Try opening locked tables for MS milliseconds\n"
274 "%timer on|off Turn SQL timer on or off\n"
275 "%trace FILE|off Output each SQL statement as it is run\n"
276 "%vfsname ?AUX? Print the name of the VFS stack\n"
277 "%width NUM1 NUM2 ... Set column widths for \"column\" mode\n"
278 " Negative values right-justify\n"
283 #: original/man1/sqlite3.1:172
289 #: original/man1/sqlite3.1:175
290 msgid "B<sqlite3> has the following options:"
294 #: original/man1/sqlite3.1:175
300 #: original/man1/sqlite3.1:178
301 msgid "Stop after hitting an error."
305 #: original/man1/sqlite3.1:178
311 #: original/man1/sqlite3.1:181
312 msgid "Force batch I/O."
316 #: original/man1/sqlite3.1:181
322 #: original/man1/sqlite3.1:186
324 "Query results will be displayed in a table like form, using whitespace "
325 "characters to separate the columns and align the output."
329 #: original/man1/sqlite3.1:186
331 msgid "B<-cmd\\ >I<command>"
335 #: original/man1/sqlite3.1:191
336 msgid "run I<command> before reading stdin"
340 #: original/man1/sqlite3.1:191
346 #: original/man1/sqlite3.1:194
347 msgid "Set output mode to CSV (comma separated values)."
351 #: original/man1/sqlite3.1:194
357 #: original/man1/sqlite3.1:197
358 msgid "Print commands before execution."
362 #: original/man1/sqlite3.1:197
364 msgid "B<-init\\ >I<file>"
368 #: original/man1/sqlite3.1:202
370 "Read and execute commands from I<file> , which can contain a mix of SQL "
371 "statements and meta-commands."
375 #: original/man1/sqlite3.1:202
377 msgid "B<-[no]header>"
381 #: original/man1/sqlite3.1:205
382 msgid "Turn headers on or off."
386 #: original/man1/sqlite3.1:205
392 #: original/man1/sqlite3.1:208
393 msgid "Show help on options and exit."
397 #: original/man1/sqlite3.1:208
403 #: original/man1/sqlite3.1:211
404 msgid "Query results will be output as simple HTML tables."
408 #: original/man1/sqlite3.1:211
410 msgid "B<-interactive>"
414 #: original/man1/sqlite3.1:214
415 msgid "Force interactive I/O."
419 #: original/man1/sqlite3.1:214
425 #: original/man1/sqlite3.1:219
427 "Query results will be displayed with one value per line, rows separated by a "
428 "blank line. Designed to be easily parsed by scripts or other programs"
432 #: original/man1/sqlite3.1:219
438 #: original/man1/sqlite3.1:223
440 "Query results will be displayed with the separator (|, by default) "
441 "character between each field value. The default."
445 #: original/man1/sqlite3.1:223
447 msgid "B<-mmap\\ >I<N>"
451 #: original/man1/sqlite3.1:227
452 msgid "Set default mmap size to I<N>"
456 #: original/man1/sqlite3.1:228
458 msgid "B<-nullvalue\\ >I<string>"
462 #: original/man1/sqlite3.1:232
463 msgid "Set string used to represent NULL values. Default is '' (empty string)."
467 #: original/man1/sqlite3.1:232
469 msgid "B<-separator\\ >I<separator>"
473 #: original/man1/sqlite3.1:235
474 msgid "Set output field separator. Default is '|'."
478 #: original/man1/sqlite3.1:235
484 #: original/man1/sqlite3.1:238
485 msgid "Print memory stats before each finalize."
489 #: original/man1/sqlite3.1:238
495 #: original/man1/sqlite3.1:241
496 msgid "Show SQLite version."
500 #: original/man1/sqlite3.1:241
502 msgid "B<-vfs\\ >I<name>"
506 #: original/man1/sqlite3.1:246
507 msgid "Use I<name> as the default VFS."
511 #: original/man1/sqlite3.1:248
517 #: original/man1/sqlite3.1:254
519 "B<sqlite3> reads an initialization file to set the configuration of the "
520 "interactive environment. Throughout initialization, any previously "
521 "specified setting can be overridden. The sequence of initialization is as "
526 #: original/man1/sqlite3.1:256
527 msgid "o The default configuration is established as follows:"
531 #: original/man1/sqlite3.1:265
535 "separator = \"|\"\n"
536 "main prompt = \"sqliteE<gt> \"\n"
537 "continue prompt = \" ...E<gt> \"\n"
542 #: original/man1/sqlite3.1:273
544 "o If the file B<~/.sqliterc> exists, it is processed first. can be found in "
545 "the user's home directory, it is read and processed. It should generally "
546 "only contain meta-commands."
550 #: original/man1/sqlite3.1:275
551 msgid "o If the -init option is present, the specified file is processed."
555 #: original/man1/sqlite3.1:277
556 msgid "o All other command line options are processed."
560 #: original/man1/sqlite3.1:278
566 #: original/man1/sqlite3.1:280
567 msgid "http://www.sqlite.org/cli.html"
571 #: original/man1/sqlite3.1:282
572 msgid "The sqlite3-doc package."
576 #: original/man1/sqlite3.1:282
582 #: original/man1/sqlite3.1:286
584 "This manual page was originally written by Andreas Rottmann "
585 "E<lt>rotty@debian.orgE<gt>, for the Debian GNU/Linux system (but may be used "
586 "by others). It was subsequently revised by Bill Bumgarner "
587 "E<lt>bbum@mac.comE<gt> and further updated by Laszlo Boszormenyi "
588 "E<lt>gcs@debian.huE<gt> ."