Escape char in pg_ls_dir - Mailing list pgsql-novice

From lgcaracol
Subject Escape char in pg_ls_dir
Date
Msg-id 1514541656508-0.post@n3.nabble.com
Whole thread Raw
Responses Re: Escape char in pg_ls_dir
List pgsql-novice
Hi,

I'm new to postgresql. I have a database running on a windows machine and I
need to use pg_ls_dir to list the contents of a folder, but I can't because
of the backslash (\), as it's not allowed.
If I run select pg_ls_dir('c:') I can see the listing of C:\, but I need to
check another folder.
If I run select pg_ls_dir(E'c:\inetpub'), I got an error "could not open
directory "c:inetpub": No such file or directory. So I now the \ is not
being used.
If I run select pg_ls_dir('c:\\inetpub'), it says "absolute path not
allowed". 

Anyone can give me a hint of how can I do this?

Thanks



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html


pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to define fixed validation tables
Next
From: Tom Lane
Date:
Subject: Re: Escape char in pg_ls_dir