From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
---|---|
To: | "Kapil Kr(dot) Khandelwal" <kapilk(at)cscape(dot)in> |
Cc: | "rod(at)iol(dot)ie" <rod(at)iol(dot)ie>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Fwd: How to run query by command prompt in Postgres |
Date: | 2012-06-27 12:11:19 |
Message-ID: | 608028210012020063@unknownmsgid |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-bugs |
Le 27 juin 2012 à 14:06, "Kapil Kr. Khandelwal" <kapilk(at)cscape(dot)in> a écrit :
Dear Sir
I want to run sql query, without any file. I have connected the db, but not
getting success run sql query.
Did you end your input with a ;
Without it, pressing return will just add another line to your 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(at)iol(dot)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(at)iol(dot)ie
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kapil Kr. Khandelwal | 2012-06-27 12:46:27 | Re: Fwd: How to run query by command prompt in Postgres |
Previous Message | Kapil Kr. Khandelwal | 2012-06-27 11:59:28 | Re: Fwd: How to run query by command prompt in Postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | Kapil Kr. Khandelwal | 2012-06-27 12:46:27 | Re: Fwd: How to run query by command prompt in Postgres |
Previous Message | Kapil Kr. Khandelwal | 2012-06-27 11:59:28 | Re: Fwd: How to run query by command prompt in Postgres |