read in to psql from file

From: Doug Moore <moored3947(at)home(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: read in to psql from file
Date: 2001-09-17 16:08:17
Message-ID: 3BA62042.8EFC0463@home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

As I understand it, in order to read in a file containing sql commands
I should use the \i <file> syntax in psql.

So, from the psql prompt I type:

\i /root/phones

I get back "/root/phones: permission denied"

I am in psql as the user who owns the database.
The file in question is readable and writeable by all.

What do I do next?

V/R,
Doug Moore

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mihai Gheorghiu 2001-09-17 16:19:04 What is faster?
Previous Message Josh Berkus 2001-09-17 15:27:31 Re: I could do with some guidance