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@xxxxxxx>: > 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. > > ----------------------------------------------------------------------------------------------------------------------- > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
