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

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

Le 27 juin 2012 =E0 14:06, "Kapil Kr. Khandelwal" <kapilk@cscape.in> a =E9c=
rit :

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@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
>
>
>

Dear Sir

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

<div class="moz-cite-prefix">On 03/20/2013 08:21 PM, Kapil Kr. Khandelwal wrote:<br /></div><blockquote
cite="mid:CAMDMQnBfyhzvua-j=FeKJvh7jpOBf2w+Quwo=CU5746tPs5HXA@mail.gmail.com"type="cite"><div dir="ltr"><span
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">DearTeam</span><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">I want to a favour from your side. I want to
implementclustering in postgres on windows server.  Please provide the list of steps. I want the  answers of followings
doubts. </div><divstyle="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px"><br /></div><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">1.How to write archive command<br
/></div></div></blockquote><a
href="http://www.postgresql.org/docs/9.2/static/runtime-config-wal.html#GUC-ARCHIVE-COMMAND">http://www.postgresql.org/docs/current/static/runtime-config-wal.html#GUC-ARCHIVE-COMMAND</a><br
/><br/> The cmd.exe "copy" command is one option. Any  Windows command that'll do what you want and doesn't require
userinteraction can be invoked there, including custom-written scripts in vbscript, Python, Perl, etc. If in doubt, ask
Googlehow do do what you want.<br /><blockquote
cite="mid:CAMDMQnBfyhzvua-j=FeKJvh7jpOBf2w+Quwo=CU5746tPs5HXA@mail.gmail.com"type="cite"><div dir="ltr"><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">2.How to log shipping from primary to stand by
server</div></div></blockquote><a
href="http://www.postgresql.org/docs/9.2/static/warm-standby.html">http://www.postgresql.org/docs/current/static/warm-standby.html</a><blockquote
cite="mid:CAMDMQnBfyhzvua-j=FeKJvh7jpOBf2w+Quwo=CU5746tPs5HXA@mail.gmail.com"type="cite"><div dir="ltr"><div
style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">3.how to restore database at stand by server
fromarchived files<br /></div></div></blockquote> Also in <a
href="http://www.postgresql.org/docs/9.2/static/warm-standby.html">http://www.postgresql.org/docs/current/static/warm-standby.html</a><br
/><br/> If you're having trouble understanding something in the documentation please explain what you've already tried,
whereyou're getting stuck, and the SPECIFIC problem you're having in a post to the pgsql-general mailing list.<br /><br
/><preclass="moz-signature" cols="72">-- Craig Ringer                   <a class="moz-txt-link-freetext"
href="http://www.2ndQuadrant.com/">http://www.2ndQuadrant.com/</a>PostgreSQLDevelopment, 24x7 Support, Training &
Services</pre>