Re: How to execute the sql file in PSQL

2020-10-06 Thread Paul Förster
Hi Mark, > On 06. Oct, 2020, at 10:23, Mark wrote: > > Actually, a single quotation will work. > \ir 'C:\\Program Files\\PostgreSQL\\12\\demo-big-en-20170815.sql' > But I don't know why a single quotation will work. > It would be very helpful if you guys can explain to me. because Microsoft

Re: How to execute the sql file in PSQL

2020-10-06 Thread Mark
Actually, a single quotation will work. \ir 'C:\\Program Files\\PostgreSQL\\12\\demo-big-en-20170815.sql' But I don't know why a single quotation will work. It would be very helpful if you guys can explain to me. On Mon, Oct 5, 2020 at 9:31 PM Tom Lane wrote: > Adrian Klaver writes: > > O

Re: How to execute the sql file in PSQL

2020-10-05 Thread Tom Lane
Adrian Klaver writes: > On 10/5/20 7:55 AM, Mark wrote: >> I followed one PostgreSQL tutorial step by step. One session to use PSQL >> to execute sql files to create a new database in PostgreSQL. >> 1.  copy  paste the sql file within "C:\Program Files\PostgreSQL\12" >> directory. >> 2.  execut

Re: How to execute the sql file in PSQL

2020-10-05 Thread Adrian Klaver
On 10/5/20 7:55 AM, Mark wrote: Stackoverflow question link: https://stackoverflow.com/questions/64210281/using-psql-executing-sql-format-file-shows-permission-denied-on-windows-platform I followed one PostgreSQL tutorial step by step. One session to use PSQL to execute sql files to create

How to execute the sql file in PSQL

2020-10-05 Thread Mark
Stackoverflow question link: https://stackoverflow.com/questions/64210281/using-psql-executing-sql-format-file-shows-permission-denied-on-windows-platform I followed one PostgreSQL tutorial step by step. One session to use PSQL to execute sql files to create a new database in PostgreSQL. 1.