| 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: | Whole Thread | Raw Message | 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 |