Sequential numbers in a query

[FatOldGit]

I need to extract a recordset that has each record numbered sequentially, does anyone know how I can do this? I am intending to save this recordset straight to a .csv file for importing into an application.

Many thanks in advance,

Dave

 

[Leland123]

Hi FatOldGit,

You can use the copy command to import and export data between postgresql and CSV files.

Use the [ copy to ] command to create a CSV file from a postgres table.

Use the [ copy from ] command to copy data from a CSV file into a postgres table.

Here is a link to the postgresql doc about the copy command.

http://www.postgresql.org/docs/7.3/static/sql-copy.html

I've worked with recordset a little in the windows OS using Visual FoxPro's OLE DB provider connected to a MS-SQL backend server. In order to work with a postgres recordset, I think you need to be working with a language and driver that support recordset.

Postgresql supports connections from java via jdbc. Here some more info:

http://developer.java.sun.com/developer/Books/JDBCTutorial/chapter5.html

LelandJ.


Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox