documentation
I read it http://www.postgresql.org/docs/8.1/interactive/tutorial-accessdb.html
I can't use examples:
maxim-# SELECT version();
ERROR: syntax error at or near "SELECT" at character 18
СТРОКА 2: SELECT version();
^
maxim=# SELECT version() ;
version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.4 on x86_64-pc-linux-gnu, compiled by GCC x86_64-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1-r1)
(1 запись)
maxim=# SELECT version();
version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.4 on x86_64-pc-linux-gnu, compiled by GCC x86_64-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1-r1)
(1 запись)
maxim=# SELECT version()
maxim-# SELECT version();
ERROR: syntax error at or near "SELECT" at character 18
СТРОКА 2: SELECT version();
^
Is it my local troubles/misunderstanding? Thanks!
--
Maxim Britov
GnuPG KeyID 0x4580A6D66F3DB1FB xmpp:maxim@modum.by icq 198171258
Fingerprint: 4059 B5C5 8985 5A47 8F5A 8623 4580 A6D6 6F3D B1FB
GnuPG-ru Team (http://lists.gnupg.org/mailman/listinfo/gnupg-ru
xmpp:gnupg-ru@conference.jabber.ru)
On Wed, 1 Nov 2006 15:57:22 +0200
Maxim Britov wrote:
I read it http://www.postgresql.org/docs/8.1/interactive/tutorial-accessdb.html
I can't use examples:
Sorry, my I know my mistake now. :)
--
Maxim Britov
GnuPG KeyID 0x4580A6D66F3DB1FB xmpp:maxim@modum.by icq 198171258
Fingerprint: 4059 B5C5 8985 5A47 8F5A 8623 4580 A6D6 6F3D B1FB
GnuPG-ru Team (http://lists.gnupg.org/mailman/listinfo/gnupg-ru
xmpp:gnupg-ru@conference.jabber.ru)
Maxim Britov <maxim.britov@gmail.com> writes:
maxim=# SELECT version()
maxim-# SELECT version();
ERROR: syntax error at or near "SELECT" at character 18
СТРОКА 2: SELECT version();
^
What you typed there was a two-line query equivalent to
SELECT version() SELECT version();
which of course is a syntax error. Notice how the prompt changed ---
that's psql's means of telling you that it's accepting a continuation
line for an incomplete query. The query ends at a semicolumn, not
a newline.
regards, tom lane