aboutsummaryrefslogtreecommitdiff
path: root/src/extend/pginsert/pginsert.c
diff options
context:
space:
mode:
authorMarc G. Fournier <scrappy@hub.org>1996-07-31 02:28:22 +0000
committerMarc G. Fournier <scrappy@hub.org>1996-07-31 02:28:22 +0000
commitc6cf21825ae8944613134d133abab8fe218c61b3 (patch)
tree3a4a366d7bc84ef35938d8b363f70ca0fb09515e /src/extend/pginsert/pginsert.c
parent3881cbd2f6ec55db2dfd7fcb84caa732a5465796 (diff)
downloadpostgresql-c6cf21825ae8944613134d133abab8fe218c61b3.tar.gz
postgresql-c6cf21825ae8944613134d133abab8fe218c61b3.zip
already exists in the contrib directory
Diffstat (limited to 'src/extend/pginsert/pginsert.c')
-rw-r--r--src/extend/pginsert/pginsert.c98
1 files changed, 0 insertions, 98 deletions
diff --git a/src/extend/pginsert/pginsert.c b/src/extend/pginsert/pginsert.c
deleted file mode 100644
index eb732c69309..00000000000
--- a/src/extend/pginsert/pginsert.c
+++ /dev/null
@@ -1,98 +0,0 @@
-/*
- * insert.c
- *
-*/
-
-#include <stdio.h>
-#include <signal.h>
-#include <time.h>
-#include <halt.h>
-#include <libpq-fe.h>
-#include "pginterface.h"
-
-int main(int argc, char **argv)
-{
- char query[4000];
- int row =1;
- int aint;
- float afloat;
- double adouble;
- char achar[11], achar16[17], abpchar[11], avarchar[51], atext[51];
- time_t aabstime;
-
- if (argc != 2)
- halt("Usage: %s database\n",argv[0]);
-
- connectdb(argv[1],NULL,NULL,NULL,NULL);
-
- skip_query_errors = 1;
- doquery("DROP TABLE testfetch");
- skip_query_errors = 0;
-
- doquery("\
- CREATE TABLE testfetch( \
- aint int4, \
- afloat float4, \
- adouble float8, \
- achar char, \
- achar16 char16, \
- abpchar char(10), \
- avarchar varchar(50), \
- atext text, \
- aabstime abstime) \
- ");
-
- while(1)
- {
- sprintf(query,"INSERT INTO testfetch VALUES ( \
- %d, \
- 2322.12, \
- '923121.0323'::float8, \
- 'A', \
- 'Betty', \
- 'Charley', \
- 'Doug', \
- 'Ernie', \
- 'now' )", row);
- doquery(query);
-
- doquery("BEGIN WORK");
- doquery("DECLARE c_testfetch BINARY CURSOR FOR \
- SELECT * FROM testfetch");
-
- doquery("FETCH ALL IN c_testfetch");
-
- while (fetch(
- &aint,
- &afloat,
- &adouble,
- achar,
- achar16,
- abpchar,
- avarchar,
- atext,
- &aabstime) != END_OF_TUPLES)
- printf("int %d\nfloat %f\ndouble %f\nchar %s\nchar16 %s\n\
-bpchar %s\nvarchar %s\ntext %s\nabstime %s",
- aint,
- afloat,
- adouble,
- achar,
- achar16,
- abpchar,
- avarchar,
- atext,
- ctime(&aabstime));
-
-
- doquery("CLOSE c_testfetch");
- doquery("COMMIT WORK");
- printf("--- %-d rows inserted so far\n",row);
-
- row++;
- }
-
- disconnectdb();
- return 0;
-}
-