Re: Any idea about using \COPY in ECPG statement
От | Pavel Stehule |
---|---|
Тема | Re: Any idea about using \COPY in ECPG statement |
Дата | |
Msg-id | CAFj8pRDTKuxSaZOk1vtLUdP+cVL9VPVH7-yA0J_wYSY0TBa2CQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Any idea about using \COPY in ECPG statement (Siva Palanisamy <siva_p@hcl.com>) |
Список | pgsql-general |
Hello its' not possible. But you don't need a superuser account for COPY necessary. You can use a SECURITY DEFINER functions. Regards Pavel Stehule 2011/8/17 Siva Palanisamy <siva_p@hcl.com>: > Hi All, > > > > Does anybody have an idea about how to write \COPY command as an ECPG > statement? > > > > EXEC SQL \COPY tablename to ‘sample.csv’ DELIMITERS ‘,’ CSV HEADER > > > > I want to perform the above psql command using an ECPG statement. No way of > using COPY due to not availability of a super-user account. Could anyone > guide me on this? > > > > Thanks and Regards, > > Siva. > > > > ________________________________ > ::DISCLAIMER:: > ----------------------------------------------------------------------------------------------------------------------- > > The contents of this e-mail and any attachment(s) are confidential and > intended for the named recipient(s) only. > It shall not attach any liability on the originator or HCL or its > affiliates. Any views or opinions presented in > this email are solely those of the author and may not necessarily reflect > the opinions of HCL or its affiliates. > Any form of reproduction, dissemination, copying, disclosure, modification, > distribution and / or publication of > this message without the prior written consent of the author of this e-mail > is strictly prohibited. If you have > received this email in error please delete it and notify the sender > immediately. Before opening any mail and > attachments please check them for viruses and defect. > > ----------------------------------------------------------------------------------------------------------------------- >
В списке pgsql-general по дате отправления: