Escape char in pg_ls_dir

Поиск
Список
Период
Сортировка
От lgcaracol
Тема Escape char in pg_ls_dir
Дата
Msg-id 1514541656508-0.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: Escape char in pg_ls_dir  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to define fixed validation tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Escape char in pg_ls_dir