contrib/binarycopy - Mailing list pgsql-patches

From Lee Kindness
Subject contrib/binarycopy
Date
Msg-id 16175.44576.571267.169389@kelvin.csl.co.uk
Whole thread Raw
Responses Re: contrib/binarycopy  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
The attached tar archive and assosciated patch adds the binarycopy
module to contrib. I believe its functionality will be of interest to
many PostgreSQL users. From the readme:

This module contains routines to create a file suitable for reading by
the COPY BINARY command. It supports the creation of 2 file formats: if
POSTGRESQL_71 is defined when building then files compatible with
PostgreSQL 7.1 through to 7.3 will be created; if POSTGRESQL_74 is defined
then files compatible with PostgreSQL 7.4 and likely later versions will
be created.

The main purpose of this is to allow writing COPY BINARY files without
caring about the underlying format and any byte-swapping issues.

Currently most integer, float, text, varchar, bytea and timestamp
fields can be output. Support for other field types can be added on an
"as-needed" basis.

binarycopy.h includes documentation for each function, and these should
be fairly straight format to understand.

Regards, Lee Kindness.

Index: contrib/Makefile
===================================================================
RCS file: /projects/cvsroot/pgsql-server/contrib/Makefile,v
retrieving revision 1.45
diff -c -r1.45 Makefile
*** contrib/Makefile    24 Jul 2003 16:54:58 -0000    1.45
--- contrib/Makefile    5 Aug 2003 12:56:04 -0000
***************
*** 6,11 ****
--- 6,12 ----

  WANTED_DIRS = \
          array        \
+         binarycopy    \
          btree_gist    \
          chkpass        \
          cube        \

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch for select() -> poll() in libpq
Next
From: Lee Kindness
Date:
Subject: COPY BINARY documentation