Re: import .sql file into PostgreSQL database - Mailing list pgsql-general

From Michael Paquier
Subject Re: import .sql file into PostgreSQL database
Date
Msg-id CAB7nPqTZxsoUPNz63uP1gNS09NXi7mmz2myYGSZJdHrz7AD1FA@mail.gmail.com
Whole thread Raw
In response to Re: import .sql file into PostgreSQL database  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: [GENERAL] import .sql file into PostgreSQL database  (Gaurav <gaurjin@gmail.com>)
List pgsql-general
On Thu, Apr 10, 2014 at 1:02 AM, Raymond O'Donnell <rod@iol.ie> wrote:
> 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.
On Windows, you need either to play with icacls to set some read
permissions or you can change it directly using the properties menu
findable by right-clicking on the culprit file.
--
Michael


pgsql-general by date:

Previous
From: Alberto Cabello Sánchez
Date:
Subject: Capture the SQL statement text with libpq [was: Re: Help]
Next
From: Steve Kehlet
Date:
Subject: Re: is there a way to firmly cap postgres worker memory consumption?