Timeline for Permission denied in file trying to import
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 3, 2020 at 13:53 | comment | added | Daniel Vérité |
Backslashes can be used if they're escaped (by being doubled) and inside a string delimited by single quotes: \i 'c:\\some\\path\\myscript.sql' does work as well as \i 'c:/some/path/myscript.sql'
|
|
| Dec 4, 2018 at 13:40 | comment | added | András Váczi | @Scaramouche thanks for the feedback! Apparently, not all permissions denied are created equal. | |
| Dec 3, 2018 at 3:09 | comment | added | Scaramouche | this didn´t work for me in windows10, forward slashes and all, user68006's answer did, though | |
| Dec 5, 2012 at 5:59 | comment | added | András Váczi |
@Celeritas I think it is the result of a conflict of how Windows uses double quotes in paths and how psql (and PostgreSQL) use it in identifiers.
|
|
| Dec 5, 2012 at 0:37 | comment | added | Celeritas | Got it thanks. How did you know to use single and not double quotes? Is that a general rule for postgres or what's the difference? | |
| Dec 5, 2012 at 0:36 | vote | accept | Celeritas | ||
| Dec 4, 2012 at 13:27 | history | answered | András Váczi | CC BY-SA 3.0 |