On 16 Aug 2003 at 11:40, Josh Berkus wrote:
> Shridhar,
>
> > Unfortunately he can not use copy due to some constraints.
>
> Why not use COPY to load the table, and then apply the constraints by query
> afterwords? It might not be faster, but then again it might.
Lol.. The constraints I mentioned weren't database constraints.. It need to
interface with another database module.. The data import can not be text..
that's a project requirement..
I should have been clearer in first place..
Bye
Shridhar
--
O'Toole's commentary on Murphy's Law: Murphy was an optimist.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
