Re: [HACKERS] COPY commands could use an enhancement.

2001-04-30 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > Do you have a alternate suggestion as to how to solve the problems it has > backing up the regression DB? One possibility is to fix ALTER TABLE ADD COLUMN to maintain the same column ordering in parents and children. COPY with specified columns may in

Re: [HACKERS] COPY commands could use an enhancement.

2001-04-30 Thread Philip Warner
At 11:36 30/04/01 -0400, Tom Lane wrote: > >COPY is designed as a simple, fast, reliable, >low-overhead data transfer mechanism for backup and restore. The more >warts we add to it, the less well it will serve that purpose. > Do you have a alternate suggestion as to how to solve the problems it

Re: [HACKERS] COPY commands could use an enhancement.

2001-04-30 Thread Fernando Nasser
Karen saw me importing data into a database using pgaccess. Again, this could be useful to someone that it is not a "superuser". But only superusers can use pgaccess. What a shame :-( Fernando P.S.: pgaccess has a much more limited import facility - only text files and you can only change the

Re: [HACKERS] COPY commands could use an enhancement.

2001-04-30 Thread Bruce Momjian
> Alfred Perlstein <[EMAIL PROTECTED]> writes: > > It would be very helpful if the COPY command could be expanded > > in order to provide positional parameters. > > I think it's a bad idea to try to expand COPY into a full-tilt data > import/conversion utility, which is the direction that this so

Re: [HACKERS] COPY commands could use an enhancement.

2001-04-30 Thread Alfred Perlstein
* Tom Lane <[EMAIL PROTECTED]> [010430 08:37] wrote: > Alfred Perlstein <[EMAIL PROTECTED]> writes: > > It would be very helpful if the COPY command could be expanded > > in order to provide positional parameters. > > I think it's a bad idea to try to expand COPY into a full-tilt data > import/co

Re: [HACKERS] COPY commands could use an enhancement.

2001-04-30 Thread Tom Lane
Alfred Perlstein <[EMAIL PROTECTED]> writes: > It would be very helpful if the COPY command could be expanded > in order to provide positional parameters. I think it's a bad idea to try to expand COPY into a full-tilt data import/conversion utility, which is the direction that this sort of sugges

[HACKERS] COPY commands could use an enhancement.

2001-04-30 Thread Alfred Perlstein
It would be very helpful if the COPY command could be expanded in order to provide positional parameters. I noticed that it didn't a while back and it can really hurt someone when they happen to try to use pg_dump to move data from one database to another database and they happened to create the