[GENERAL] bulk copy in postgresql

Title: bulk copy in postgresql Hi. Can someone please tell me if there is a tool in postgres similar to BCP? I need to populate some tables using data from some text files and don't know how to do it. Thanks in advance, Carlos Felipe Zirbes

[GENERAL] How do I set digest?

Help, I'm drowining in eMail... anybody know how to set digest mode? Thanks Rob

Re: [GENERAL] Using aggregates in a select query

On Tue, Mar 21, 2000 at 04:07:20PM -0800, Arthur M. Kang wrote: > Was wondering if there was a way to use an aggregate value in a single > select query to make a calculation within that query... > > Example: > Table has column bool of type boolean with various random boolean > values. > > Want t

[GENERAL] Scheduling Vacuumdb

Does anyone see a problem with executing something similar to this on a nightly basis (in a Cron job) to run vacuum on all databases? -- #!/usr/bin/perl while (<`ls -1 /usr/local/pgsql/data/base`>) { `/usr/local/pgsql/bin/vacuumdb $_`; } ---

Re: [GENERAL] docs and mailinglistarchives

On Wed, 22 Mar 2000, Henk van Lingen wrote: > Hi all, > > Is it possible to get the mailinglistarchives back in sync on the > website or does majordomo2 something to prevent this? RSN ...

[GENERAL] docs and mailinglistarchives

Hi all, Is it possible to get the mailinglistarchives back in sync on the website or does majordomo2 something to prevent this? And is there a special reason why the beta versions don't have the current documentation in /doc ? I know, the source is there but you have to have the right tools to m

Re: [GENERAL] Alternate location

On Wed, 22 Mar 2000, Stefano Bargioni wrote: > Dear Peter, thank you, the manual has an error: in the initlocation command, > the $ must be deleted; but there is still a problem with createdb: Yes, thank you. > $ createdb -D PGDATA2 ucc2 > ERROR: Unable to locate path 'PGDATA2/ucc2' >

Re: [GENERAL] Alternate location

Peter Eisentraut wrote: > On Wed, 22 Mar 2000, Stefano Bargioni wrote: > > > $ PGDATA2=/data > > $ initlocation $PGDATA2 > > initlocation PGDATA2 > > > We are initializing the database area with username postgres (uid=40). > > This user will own all the files and must also own the server process.

Re: [GENERAL] Alternate location

On Wed, 22 Mar 2000, Stefano Bargioni wrote: > $ PGDATA2=/data > $ initlocation $PGDATA2 initlocation PGDATA2 > We are initializing the database area with username postgres (uid=40). > This user will own all the files and must also own the server process. > $ createdb -D $PGDATA2 ucc2 createdb

[GENERAL] Alternate location

Hi, I need to define a very large db in a disk partition /data that is not the default partition of Postgres. The Chapter 10 of the admin guide describes a procedure that fails (postgres 6.5.3): $ PGDATA2=/data $ initlocation $PGDATA2 We are initializing the database area with username postgres (

Re: [GENERAL] Problem with LIKE operator

Hi, Finally I have found the problem: the table was corrupted, so i have recreated it and it works fine. I wonder if instead of recreating it i would have had to execute a vacuum. Thanks to you all for your help and your suggestions (i will keep them for the future). Gabi :-)