Re: [GENERAL] COPY TO order

2004-04-12 Thread Clodoaldo Pinto Neto
--- Guy Fraser <[EMAIL PROTECTED]> > If you have a 'serial' or 'bigserial' field like this : > > create table test_table ( > test_id bigserial, > data integer, > comment text > ); > > and you use : > > copy test_table (data,comment) > from '/wherever/the/file/is' > using delimiters ','; > >

Re: [GENERAL] COPY TO order

2004-04-12 Thread Guy Fraser
Christopher Browne wrote: Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Clodoaldo Pinto Neto) would write: How to make sure COPY TO writes the table lines to the file in the same order they were inserted? You probably want to rewrite PostgreSQL then. I'm producing html pag

Re: [GENERAL] COPY TO order

2004-04-10 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Clodoaldo Pinto Neto) would write: > How to make sure COPY TO writes the table lines to the file in the same order > they were inserted? You probably want to rewrite PostgreSQL then. > I'm producing html pages in pl/pgsql and using COPY