aboutsummaryrefslogtreecommitdiff
path: root/src/interfaces/libpgeasy/examples/pginsert.c
diff options
context:
space:
mode:
authorMarc G. Fournier <scrappy@hub.org>2002-08-30 13:03:11 +0000
committerMarc G. Fournier <scrappy@hub.org>2002-08-30 13:03:11 +0000
commitc411f51dfbb92848c22188e5d6df968034adb98d (patch)
tree7ed4002f11ad35fe5a3643a55ee989ef10cee29c /src/interfaces/libpgeasy/examples/pginsert.c
parentdf40e28850eed2b1440ddada849005fb9819201a (diff)
downloadpostgresql-c411f51dfbb92848c22188e5d6df968034adb98d.tar.gz
postgresql-c411f51dfbb92848c22188e5d6df968034adb98d.zip
libpgeasy moved to gborg ...
Diffstat (limited to 'src/interfaces/libpgeasy/examples/pginsert.c')
-rw-r--r--src/interfaces/libpgeasy/examples/pginsert.c98
1 files changed, 0 insertions, 98 deletions
diff --git a/src/interfaces/libpgeasy/examples/pginsert.c b/src/interfaces/libpgeasy/examples/pginsert.c
deleted file mode 100644
index 85b181b541c..00000000000
--- a/src/interfaces/libpgeasy/examples/pginsert.c
+++ /dev/null
@@ -1,98 +0,0 @@
-/*
- * insert.c
- *
-*/
-
-#include <stdio.h>
-#include <time.h>
-#include "libpq-fe.h"
-#include "../halt.h"
-#include "libpgeasy.h"
-
-int
-main(int argc, char **argv)
-{
- char query[4000];
- int row = 1;
- int aint;
- float afloat;
- double adouble;
- char achar[11],
- abpchar[11],
- avarchar[51],
- atext[51];
- time_t aabstime;
- char optstr[256];
-
- if (argc != 2)
- halt("Usage: %s database\n", argv[0]);
-
- snprintf(optstr, 256, "dbname=%s", argv[1]);
- connectdb(optstr);
-
- on_error_continue();
- doquery("DROP TABLE testfetch");
- on_error_stop();
-
- doquery("\
- CREATE TABLE testfetch( \
- aint int4, \
- afloat float4, \
- adouble float8, \
- achar char, \
- 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', \
- '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,
- abpchar,
- avarchar,
- atext,
- &aabstime) != END_OF_TUPLES)
- printf("int %d\nfloat %f\ndouble %f\nchar %s\n\
-bpchar %s\nvarchar %s\ntext %s\nabstime %s",
- aint,
- afloat,
- adouble,
- achar,
- abpchar,
- avarchar,
- atext,
- ctime(&aabstime));
-
-
- doquery("CLOSE c_testfetch");
- doquery("COMMIT WORK");
- printf("--- %-d rows inserted so far\n", row);
-
- row++;
- }
-
- disconnectdb();
- return 0;
-}