Re: Any idea about using \COPY in ECPG statement

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.
>
>
-----------------------------------------------------------------------------------------------------------------------
>