pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedfailed to create directory in postgresql
6+ messages / 4 participants
[nested] [flat]
* failed to create directory in postgresql
@ 2022-10-28 08:04 Nikhil Ingale <niks.bgm@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Nikhil Ingale @ 2022-10-28 08:04 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi All,
I'm trying to create the directory but unable to do it. I don't find this
command anywhere in postgresql. But the EDB suggests using this command to
create a directory.
postgres=# create directory utildir as '/tmp/utildir';
ERROR: syntax error at or near "directory"
LINE 1: create directory utildir as '/tmp/utildir';
^
Regards,
Nikhil
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: failed to create directory in postgresql
@ 2022-10-28 08:10 Julien Rouhaud <rjuju123@gmail.com>
parent: Nikhil Ingale <niks.bgm@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Julien Rouhaud @ 2022-10-28 08:10 UTC (permalink / raw)
To: Nikhil Ingale <niks.bgm@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi,
On Fri, Oct 28, 2022 at 01:34:44PM +0530, Nikhil Ingale wrote:
> I'm trying to create the directory but unable to do it. I don't find this
> command anywhere in postgresql. But the EDB suggests using this command to
> create a directory.
>
> postgres=# create directory utildir as '/tmp/utildir';
> ERROR: syntax error at or near "directory"
> LINE 1: create directory utildir as '/tmp/utildir';
> ^
This is an EDB-specific command, community version doesn't have it.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: failed to create directory in postgresql
@ 2022-10-28 08:16 Nikhil Ingale <niks.bgm@gmail.com>
parent: Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Nikhil Ingale @ 2022-10-28 08:16 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Do we need to install extension to get it work?
On Fri, Oct 28, 2022 at 1:40 PM Julien Rouhaud <rjuju123@gmail.com> wrote:
> Hi,
>
> On Fri, Oct 28, 2022 at 01:34:44PM +0530, Nikhil Ingale wrote:
> > I'm trying to create the directory but unable to do it. I don't find this
> > command anywhere in postgresql. But the EDB suggests using this command
> to
> > create a directory.
> >
> > postgres=# create directory utildir as '/tmp/utildir';
> > ERROR: syntax error at or near "directory"
> > LINE 1: create directory utildir as '/tmp/utildir';
> > ^
>
> This is an EDB-specific command, community version doesn't have it.
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: failed to create directory in postgresql
@ 2022-10-28 08:18 Julien Rouhaud <rjuju123@gmail.com>
parent: Nikhil Ingale <niks.bgm@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Julien Rouhaud @ 2022-10-28 08:18 UTC (permalink / raw)
To: Nikhil Ingale <niks.bgm@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Fri, Oct 28, 2022 at 01:46:02PM +0530, Nikhil Ingale wrote:
> Do we need to install extension to get it work?
No, you need to buy their product and use it.
What problem exactly are you trying to solve?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: failed to create directory in postgresql
@ 2022-10-28 08:23 Samed YILDIRIM <samed@reddoc.net>
parent: Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Samed YILDIRIM @ 2022-10-28 08:23 UTC (permalink / raw)
To: Nikhil Ingale <niks.bgm@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hello Nikhil,
Can you explain what you try to achieve? You probably try doing some
practices you know from Oracle experience. Why do you need to create a
directory on filesystem through PostgreSQL interface?
Best regards.
Samed YILDIRIM
On Fri, 28 Oct 2022, 10:18 Julien Rouhaud, <rjuju123@gmail.com> wrote:
> On Fri, Oct 28, 2022 at 01:46:02PM +0530, Nikhil Ingale wrote:
> > Do we need to install extension to get it work?
>
> No, you need to buy their product and use it.
>
> What problem exactly are you trying to solve?
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: failed to create directory in postgresql
@ 2022-10-28 09:33 Thomas Kellerer <shammat@gmx.net>
parent: Samed YILDIRIM <samed@reddoc.net>
0 siblings, 0 replies; 6+ messages in thread
From: Thomas Kellerer @ 2022-10-28 09:33 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Samed YILDIRIM schrieb am 28.10.2022 um 10:23:
> Can you explain what you try to achieve? You probably try doing some
> practices you know from Oracle experience. Why do you need to create
> a directory on filesystem through PostgreSQL interface?
In Oracle, CREATE DIRECTORY doesn't actually create a directory in the filesystem
It essentially _registers_ an existing filesystem directory with Oracle so
that it can be used e.g. for datapump or external tables.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2022-10-28 09:33 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-28 08:04 failed to create directory in postgresql Nikhil Ingale <niks.bgm@gmail.com>
2022-10-28 08:10 ` Julien Rouhaud <rjuju123@gmail.com>
2022-10-28 08:16 ` Nikhil Ingale <niks.bgm@gmail.com>
2022-10-28 08:18 ` Julien Rouhaud <rjuju123@gmail.com>
2022-10-28 08:23 ` Samed YILDIRIM <samed@reddoc.net>
2022-10-28 09:33 ` Thomas Kellerer <shammat@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox