Hi,

First of all, thank you for your answers.

Look at this file output:

                                               url_negado
------------------------------------------------------------------------------------------------------
  www.startux.org
  www.hotmail.com
  www.blabla.com
(3 rows)


Is there a way to postgres not print the 1st, 2nd and last line ?
I need a list just with URLs.

Thank you in advance.

Warm Regards,
Mário Gamito

Oliver Elphick wrote:
> On Tue, 2004-08-24 at 18:08, Mário Gamito wrote:
> 
>>Hi,
>>
>>How can i draw the results of a SELECT in to a file in the filesystem ?
> 
> 
> Using psql:
> 
>   1.  \o /path/to/file
>       SELECT ... ;
>       \o
> 
>   2. psql -d my_database -c "SELECT ... " >/path/to/file
> 

In response to

• Re: SELECT to an external file at 2004-08-24 17:13:59 from Oliver Elphick

Responses

• Re: SELECT to an external file at 2004-08-24 17:35:49 from Jeff Amiel

pgsql-general by date

Next:	From: Jeff Amiel	Date: 2004-08-24 17:22:12
	Subject: Re: SELECT to an external file
Previous:	From: David Wheeler	Date: 2004-08-24 17:17:01
	Subject: Re: UTF-8 and LIKE vs =