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

Поиск
Список
Период
Сортировка
От Kapil Kr. Khandelwal
Тема Re: Fwd: How to run query by command prompt in Postgres
Дата
Msg-id CAMDMQnBfyhzvua-j=FeKJvh7jpOBf2w+Quwo=CU5746tPs5HXA@mail.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  (Craig Ringer <craig@2ndquadrant.com>)
Список pgadmin-support
Дерево обсуждения
Dear Team

I want to a favour from your side. I want to implement clustering in postgres on windows server.  Please provide the list of steps. I want the  answers of followings doubts. 

1. How to write archive command
2. How to log shipping from primary to stand by server
3. how to restore database at stand by server from archived files

I am waiting for your positive response. Thanks in advance.


Regards
Kapil Kr. Khandelwal
CodeScape Consultant Pvt Ltd
+91 969 417 9109
+91 141 400 2993
www.codescape.in

 Think before printing. Turn off Systems before leaving. Conserve Energy, Save our Environment.




On Wed, Jun 27, 2012 at 5:29 PM, Kapil Kr. Khandelwal <kapilk@cscape.in> wrote:
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 по дате отправления:

Предыдущее
От: "Kapil Kr. Khandelwal"
Дата:
Сообщение: Re: How to run query by command prompt in Postgres
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Fwd: How to run query by command prompt in Postgres