Skip site navigation (1) Skip section navigation (2)

Re: SELECT to an external file

From: Mário Gamito <gamito(at)netual(dot)pt>
To: olly(at)lfix(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT to an external file
Date: 2004-08-24 17:20:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

First of all, thank you for your answers.

Look at this file output:

(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:
>>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


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group