Re: contrib/binarycopy

This has been saved for the 7.5 release:

http:/momjian.postgresql.org/cgi-bin/pgpatches2

---------------------------------------------------------------------------

Lee Kindness wrote:
Content-Description: message body text

> 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.
>

[ Attachment, skipping... ]

> 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 \

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073