MySQL 讌 . ? 蠍磯レ 碁Π. 讌企 るジ DBMS 覲 蠍磯ル 谿場覲 . 殊 蠍磯ル...螳
PostgreSQL 焔レ 伎 殊螻 . 焔? 螳朱 DBMS豌伎 焔レ 碁り 螳. 讌 DBMS襯 襷讌 覓語手 覲碁. 覘..伎...覃伎殊 覲企伎 豌豌 螳覲企襦 ...
C:\>psql --help
This is psql 8.0.1, the PostgreSQL interactive terminal.
Usage:
psql [OPTIONS]... [DBNAME [USERNAME]]
General options:
-d DBNAME specify database name to connect to (default: "yasi")
-c COMMAND run only single command (SQL or internal) and exit
-f FILENAME execute commands from file, then exit
-l list available databases, then exit
-v NAME=VALUE set psql variable NAME to VALUE
-X do not read startup file (~/.psqlrc)
--help show this help, then exit
--version output version information, then exit
Input and output options:
-a echo all input from script
-e echo commands sent to server
-E display queries that internal commands generate
-q run quietly (no messages, only query output)
-o FILENAME send query results to file (or |pipe)
-n disable enhanced command line editing (readline)
-s single-step mode (confirm each query)
-S single-line mode (end of line terminates SQL command)
Output format options:
-A unaligned table output mode (-P format=unaligned)
-H HTML table output mode (-P format=html)
-t print rows only (-P tuples_only)
-T TEXT set HTML table tag attributes (width, border) (-P tableattr=)
-x turn on expanded table output (-P expanded)
-P VAR[=ARG] set printing option VAR to ARG (see \pset command)
-F STRING set field separator (default: "|") (-P fieldsep=)
-R STRING set record separator (default: newline) (-P recordsep=)
Connection options:
-h HOSTNAME database server host or socket directory (default: "local sock
et")
-p PORT database server port (default: "5432")
-U NAME database user name (default: "yasi")
-W prompt for password (should happen automatically)
For more information, type "\?" (for internal commands) or "\help"
(for SQL commands) from within psql, or consult the psql section in
the PostgreSQL documentation.
Report bugs to <pgsql-bugs@postgresql.org>.
C:\>psql "Pervasive Demo DB"
Password:
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
Pervasive Demo DB=> select version();
version
-----------------------------------------------------------------------------------------------------
PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1)
(1 row)
Pervasive Demo DB=> select current_date();
ERROR: syntax error at or near "(" at character 20
LINE 1: select current_date();
^
Pervasive Demo DB=> select current_date;
date
------------
2005-06-13
(1 row)
Pervasive Demo DB=> select 2 + 2;
?column?
----------
4
(1 row)
Pervasive Demo DB=> select 2 + '2';
?column?
----------
4
(1 row)
Pervasive Demo DB=> select '2' + '2';
ERROR: operator is not unique: "unknown" + "unknown"
HINT: Could not choose a best candidate operator. You may need to add explicit type casts.
Pervasive Demo DB=> select '2' || '2';
?column?
----------
22
(1 row)
Pervasive Demo DB=>