Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B91919FB627 for ; Mon, 7 May 2007 06:21:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 09717-04 for ; Mon, 7 May 2007 06:21:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 66B269FB666 for ; Mon, 7 May 2007 06:21:41 -0300 (ADT) Received: (qmail 8666 invoked from network); 7 May 2007 09:21:38 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;041392f40a2d7b9dac07cfd035bf904d; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 7 May 2007 09:21:38 -0000 Received: (qmail 11551 invoked by uid 1166); 7 May 2007 19:21:31 +1000 Received: from 203.214.90.62 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:0(203.214.90.62):. Processed in 0.278093 secs); 07 May 2007 09:21:31 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:0(203.214.90.62):. Processed in 0.278093 secs Process 11543) Received: from 203-214-90-62.dyn.iinet.net.au (HELO ?192.168.1.253?) (phillip.smith@weatherbeeta.com.au@203.214.90.62) by mail.weatherbeeta.com.au with SMTP; 7 May 2007 19:21:30 +1000 Subject: Re: [SQL] syntax error in "createdb" From: Phillip Smith Reply-To: phillip.smith@weatherbeeta.com.au To: kannan kk Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: <530656.87382.qm@web8912.mail.in.yahoo.com> References: <530656.87382.qm@web8912.mail.in.yahoo.com> Content-Type: multipart/alternative; boundary="=-++yLhshvQJQ3fXu6ltAf" Organization: Weatherbeeta P/L Date: Mon, 07 May 2007 19:25:34 +1000 Message-Id: <1178529934.4760.26.camel@fukawi2.homelinux.net> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1178529698.131-8655-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.03/0.25 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/239 X-Sequence-Number: 113434 --=-++yLhshvQJQ3fXu6ltAf Content-Type: text/plain Content-Transfer-Encoding: 7bit Where are you trying to execute these commands? They should be run at the command line as they are 'standalone' programs, not SQL commands to be run in an SQL session. On Mon, 2007-05-07 at 10:01 +0100, kannan kk wrote: > hello > > when i try to execute createdb,psql,pg_dump,pg_restore and similar > postgre commands , i get > syntax at or near 'createdb' and similar to other statements. > > plz help me wht would be the problem. > > > > ______________________________________________________________________ > Office firewalls, cyber cafes, college labs, don't allow you to > download CHAT? Here's a solution! *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments --=-++yLhshvQJQ3fXu6ltAf Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Where are you trying to execute these commands? They should be run at the command line as they are 'standalone' programs, not SQL commands to be run in an SQL session.

On Mon, 2007-05-07 at 10:01 +0100, kannan kk wrote:
hello

when i try to execute createdb,psql,pg_dump,pg_restore and similar postgre commands , i get
syntax at or near 'createdb' and similar to other statements.

plz help me wht would be the problem.




Office firewalls, cyber cafes, college labs, don't allow you to download CHAT? Here's a solution!

*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email.

Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments
--=-++yLhshvQJQ3fXu6ltAf--