Re: Problem running script

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Sushma Sagaram <sushma(dot)2276(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Problem running script
Date: 2008-07-24 07:15:54
Message-ID: 48882C2A.8000801@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-general

Sushma Sagaram a écrit :
> My requirement is to write a query in a file read the input from that
> file run in postgresql and write the output(query results) into a file.
> I'm not able to sue combination of \i and \o
> Let' say I have file test.sql and in test.sql I write
> select * from abc;
>
> Now I need to read the query from the file and write the output to a
> file. I tried
> =>\i test.sql \o test
>

=> \o test
and then
=> \i test.sql

But this is not related to pgadmin. You should have ask on pgsql-general.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message osalcedo 2008-07-25 16:53:25 problemas al crear el servicio
Previous Message Sushma Sagaram 2008-07-23 23:32:19 Problem running script

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2008-07-24 07:19:36 Re: pg_query transaction: auto rollback? begin or start?? commit or end???
Previous Message Harvey, Allan AC 2008-07-24 06:28:15 Re: 8.3.3 regression test on SCO 5.0.7