From: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
---|---|
To: | Mark <jxustnc(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to execute the sql file in PSQL |
Date: | 2020-10-06 09:53:00 |
Message-ID: | EC0B814D-C38C-4BB5-B9A3-BC22DC68DAC1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Mark,
> On 06. Oct, 2020, at 10:23, Mark <jxustnc(at)gmail(dot)com> 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 had the glorious idea of putting a blank character into "Program Files". Quoting this will make the whole C:\...sql line one single word which is then passed to \i.
Cheers,
Paul
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2020-10-06 12:45:52 | Re: How to update a table with the result of deleting rows in another table |
Previous Message | Jayaram | 2020-10-06 09:05:19 | RE: Handling time series data with PostgreSQL |