Re: import .sql file into PostgreSQL database

On 08/04/2014 04:47, Michael Paquier wrote:
> On Tue, Apr 8, 2014 at 12:33 PM, Gaurav Jindal <gaurjin(at)gmail(dot)com> wrote:
>> How to import the .sql file using PSQL or PgAdmin? Can anyone guide me with
>> details and step by step instructions.
>>
>> I tried \i filename.sql command but permission denied. I don't know how to
>> make it work. Can anyone helps me out. Thanks!
> As you mentionned "¥i $FILE" (as is psql -f $FILE) is just fine, as
> you are getting a permission error just be sure that the user that is
> using the client application has a read access to the sql file you are
> trying to use.

Where is the "Permission denied" coming from? - the OS, or Postgres?

Check, in addition to the above, that the Postgres user you're using for
the connection has the requisite INSERT, SELECT (etc) permissions on the
database objects.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie