Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: How to run query by command prompt in Postgres - Mailing list pgadmin-support

From Kapil Kr. Khandelwal
Subject Re: Fwd: How to run query by command prompt in Postgres
Date
Msg-id CAMDMQnAwurTAu4J=C5ucJW1tGtrsVgixJiXerZuxBTRDOX69aQ@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: How to run query by command prompt in Postgres  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: Fwd: How to run query by command prompt in Postgres  (Julien Rouhaud <rjuju123@gmail.com>)
Re: Fwd: How to run query by command prompt in Postgres  ("Kapil Kr. Khandelwal" <kapilk@cscape.in>)
Re: Fwd: How to run query by command prompt in Postgres  (Julien Rouhaud <rjuju123@gmail.com>)
List pgadmin-support
Tree view
Dear Sir

I want to run sql query, without any file. I have connected the db, but not getting success run sql query. 


I can run by file, if you can provide me steps of this. 

Looking forward to positive response from your side. Thanks in advance. 


Thanks & Regards

Kapil Kr. Khandelwal
M: 09694179109
CodeScape Consultants, Jaipur



On Wed, Jun 27, 2012 at 5:21 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 27/06/2012 12:18, Kapil Kr. Khandelwal wrote:
>
>
> Dear Team
>
> I want to a favour from your side. I want to know, how to run sql query
> by command prompt in postgres sql.

psql -f file-with-query.sql your-database


http://www.postgresql.org/docs/9.1/static/app-psql.html


Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



pgadmin-support by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Fwd: How to run query by command prompt in Postgres
Next
From: Julien Rouhaud
Date:
Subject: Re: Fwd: How to run query by command prompt in Postgres