Mercurial > sqlpython

comparison docs/source/capabilities.rst @ 247:f0f293d83337

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
begin docs
author catherine@dellzilla
date Wed, 04 Mar 2009 17:44:29 -0500
parents
children 3c5fa8ed4f8b
comparison
equal deleted inserted replaced
246:b5d4a122354a 247:f0f293d83337
1 SQLPython's extra capabilities
2 ==============================
3
4 For the most part, SQLPython simply duplicates SQL\*Plus's capabilites.
5
6 UNIX-like commands
7 ==================
8
9 ls
10 Lists objects from the data dictionaries. There are implied wildcards at the beginning and
11 end
12
13 cat
14 Shorthand for "SELECT * FROM"
15
16 PostgreSQL-like shortcuts
17 =========================
18
19 ----- ------------------
20 z y
21 ----- ------------------
22 \\c connect
23 \\d desc
24 \\e edit
25 \\g run
26 \\h help
27 \\i load
28 \\o spool
29 \\p list
30 \\q quit
31 \\w save
32 \\db _dir_tablespaces
33 \\dd comments
34 \\dn _dir_schemas
35 \\dt _dir_tables
36 \\dv _dir_views
37 \\di _dir_indexes
38 \\? help psql
39 ----- ------------------
40
41 Wild SQL
42 ========
43
44 Wild SQL is a nonstandard SQL feature that must be enabled with `set wildsql on`. When it is
45 enabled, column names in a SELECT statement do not need to be explicitly typed.
46
47 * % or \* as wildcards::
48
49 SELECT d* FROM v$database;
50
51 SELECT
52
53 Wild SQL can only be used in the primary column list of straightforward SELECT statements,
54 not in subqueries, `UNION`ed queries, etc.