Re: [GENERAL] import .sql file into PostgreSQL database

2014-04-09 Thread Michael Paquier
On Thu, Apr 10, 2014 at 1:02 AM, Raymond O'Donnell 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

Re: [GENERAL] import .sql file into PostgreSQL database

2014-04-09 Thread Raymond O'Donnell
On 09/04/2014 03:42, Gaurav Jindal wrote: > Inline image 1 > > > On Tue, Apr 8, 2014 at 5:21 PM, > 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. > Tab

Re: [GENERAL] import .sql file into PostgreSQL database

2014-04-08 Thread Raymond O'Donnell
On 08/04/2014 04:47, Michael Paquier wrote: > On Tue, Apr 8, 2014 at 12:33 PM, Gaurav Jindal 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

Re: [GENERAL] import .sql file into PostgreSQL database

2014-04-07 Thread Michael Paquier
On Tue, Apr 8, 2014 at 12:33 PM, Gaurav Jindal 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. Thank

[GENERAL] import .sql file into PostgreSQL database

2014-04-07 Thread Gaurav Jindal
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! Gaurav