Re: Fwd: How to run query by command prompt in Postgres

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: "Kapil Kr(dot) Khandelwal" <kapilk(at)cscape(dot)in>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Fwd: How to run query by command prompt in Postgres
Date: 2012-06-27 11:51:22
Message-ID: 4FEAF3BA.40707@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-bugs

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(at)iol(dot)ie

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Kapil Kr. Khandelwal 2012-06-27 11:59:28 Re: Fwd: How to run query by command prompt in Postgres
Previous Message Kapil Kr. Khandelwal 2012-06-27 11:18:45 Fwd: How to run query by command prompt in Postgres

Browse pgsql-bugs by date

  From Date Subject
Next Message Kapil Kr. Khandelwal 2012-06-27 11:59:28 Re: Fwd: How to run query by command prompt in Postgres
Previous Message Kapil Kr. Khandelwal 2012-06-27 11:18:45 Fwd: How to run query by command prompt in Postgres