Re: COPY TABLE TO

"Paul Punett" <paul.punett@shazamteam.com> writes:
> I need count as the first record? Any suggestions please ?

SQL does not guarantee any particular ordering of rows in a table.
You cannot do what you're doing and expect it to be reliable.

You could do something like this: add a sequence-number column to your
table and then do "SELECT ... ORDER BY seqno" to extract the data in
a controlled order.
        regards, tom lane