Re: [GENERAL] Dump all in several files

2005-03-15 Thread javier wilson
On Tue, 15 Mar 2005 17:01:39 +0100, Frederic Massot [EMAIL PROTECTED] wrote: Lonni J Friedman wrote: On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot [EMAIL PROTECTED] wrote: Hi, On the PostgreSQL 6.5 server I use this shell script (see below) for the backup all of the database in

Re: [GENERAL] Dump all in several files

2005-03-15 Thread javier wilson
On Tue, 15 Mar 2005 12:15:39 -0400, Alvaro Herrera [EMAIL PROTECTED] wrote: On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote: Lonni J Friedman wrote: On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot [EMAIL PROTECTED] wrote: Hi, On the PostgreSQL 6.5 server I use

Re: [GENERAL] PostgreSQL still for Linux only?

2005-03-08 Thread javier wilson
On Tuesday 08 March 2005 07:24 pm, Tope Akinniyi wrote: Hi, I am wondering at this display of extreme Linux mentality being displayed by the 'top bras' of the PostgreSQL community. And I ask, are we encouraging Windows use of PostgreSQL at all? Take a look at tools being rolled out

Re: [GENERAL] Novice Question

2005-03-01 Thread javier wilson
On Tue, 01 Mar 2005 16:30:19 -0500, Michael Romagnoli [EMAIL PROTECTED] wrote: Sorry, I meant to ask about copying databases, not tables (including all data in the database as per below). you can do a pg_dump your_databaseyour_database.dump.sql and then createdb to create your new database,

Re: [GENERAL] Help with seq numbers...

2005-02-14 Thread javier wilson
On Mon, 14 Feb 2005 15:47:06 -0600, Cristian Prieto [EMAIL PROTECTED] wrote: why don't you use a serial? that way you don't have to insert it? i usually let postgresql take care of it, and you can use currval to return a value. That's the trouble, I need a sp that returns the user id of

[GENERAL] create aggregates to concatenate

2005-02-08 Thread javier wilson
in... etc): SELECT paises.pais, pegar(ciudad) FROM ciudades JOIN paises ON ciudades.pais=paises.pais GROUP BY paises.pais if i'm missing something or doing something wrong please let me know, this is my first aggregate function. javier wilson guegue.com ---(end of broadcast

Re: [GENERAL] Database permissions

2005-02-08 Thread javier wilson
local is for all local connections, phppgadmin i guess is local, if run on the same computer could be local, depending on your configuration. is access and odbc on a different computer? in that case you could add host all all ipnumber mask trust to allow access to all databeses as any user for

[GENERAL] tcl and rpms for rhel3

2004-07-15 Thread javier wilson
i just build the rpm for rhel3 based on postgresql-7.4.3-3PGDG.src.rpm but i did not get the postgresql-tcl package. i looked for it in some mirrors like ftp://ftp22.us.postgresql.org/mirrors/www.postgresql.org/binary/v7.4.3/redhat/rhel3/ but apparently it is not included in the RPM version of