> psql -U abc -d DB_NAME
> At the Postgresql prompt, I type \i d:\abc.sql
> but got a D:: Permission denied
> I have added MACHINE_NAME\postgres user to d: drive and its subfolders
> but am still getting the above error.
> Do you have any idea what can be wrong? abc.sql is a stored function.
Here is another link for psql commands:
http://www.postgresql.org/docs/8.0/static/app-psql.html
if you notice your error message shows two colons in "D::". Maybe it is a path problem.
try:
psql> \!pwd --to get your current working directory.
Also from the above page:
Parsing for arguments stops when another unquoted backslash occurs. This is taken as the beginning
of a new meta-command. The special sequence \\ (two backslashes) marks the end of arguments and
continues parsing SQL commands, if any. That way SQL and psql commands can be freely mixed on a
line. But in any case, the arguments of a meta-command cannot continue beyond the end of the line.
So maybe the path "d:\abc.sql" the single \ is giving you problems. Maybe try d:\\abc.sql.
or try:
psql> \cd d:\\ --to change to this directory
this simply try:
psql> \i abc.sql
regards,
Richard Broersma Jr.