Re: [GENERAL] PostgresQL equivalent of NOCOUNT

2001-08-14 Thread Dwayne Miller
Jochem van Dieten wrote: > Dwayne Miller wrote: > >> >> SELECT nextval('mysequence') AS PKEY FROM DUAL; >> ... >> Your inserts and updates using #queryname.pkey# > > > I know, but it has 2 queries again, which is exactly the reason why I >

[GENERAL] COPY command with timestamp and NULLs

2001-09-10 Thread Dwayne Miller
I recently upgraded to 7.1.3. I was experimenting with a script to export data from FoxPro into an SQL file and multiple data files. The SQL file creates the tables, indexes, foreign keys, etc, and calls the COPY command to load the data from the appropriate data files. It appears, and I cou