lt;[EMAIL PROTECTED]>
Sent: Monday, December 22, 2003 8:35 AM
Subject: [HACKERS] COPY TABLE TO
> Hi,
>
> I need to write a tab separated text file such that the first row contains
> number of records in the table.
> I insert first row with '0' (zero) as first column &a
"Paul Punett" <[EMAIL PROTECTED]> 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
On Mon, Dec 22, 2003 at 10:35:08AM -, Paul Punett wrote:
>
> I need to write a tab separated text file such that the first row contains
> number of records in the table.
Whether COPY does what you want may depend on what you want to do with
special characters. If your table contains strings
Hi,
I need to write a tab separated text file such that the first row contains
number of records in the table.
I insert first row with '0' (zero) as first column & rest columns NULL.
Then at the end of writing records to table I do a select into Variable
count(*) from table.
& update the first rec