Re: import .sql file into PostgreSQL database

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Gaurav Jindal <gaurjin(at)gmail(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, 'PostgreSQL' <pgsql-general(at)postgresql(dot)org>
Subject: Re: import .sql file into PostgreSQL database
Date: 2014-04-09 16:02:36
Message-ID: 53456F1C.90509@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/04/2014 03:42, Gaurav Jindal wrote:
> Inline image 1
>
>
> On Tue, Apr 8, 2014 at 5:21 PM, <gaurjin(at)gmail(dot)com
> <mailto:gaurjin(at)gmail(dot)com>> wrote:
>
> > - Your OS
> Windows 7
> > - What version of PostgreSQL you have
> 9.3.4
> > - What is in the SQL file you're trying to execute.
> Tables and their description
> > - The EXACT error message that you're getting.
> Permission denied when I run
> \i dump.sql in psql

Please keep your replies on-list.

I think that message is coming from the OS; messages from Postgres are
usual more specific, for example, "Permission denied for relation....".

It looks as if you haven't the OS permissions to read the SQL file.

Ray.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2014-04-09 17:23:40 Re: openssl heartbleed
Previous Message Andrew Sullivan 2014-04-09 15:56:30 Re: openssl heartbleed