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 P
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 al
> 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 be
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_database>your_database.dump.sql
and then createdb to create your new datab
i guess you can create a simple sql function:
http://www.postgresql.org/docs/8.0/interactive/xfunc-sql.html
or more complex pl/pgsql functions
http://www.postgresql.org/docs/8.0/interactive/xplang.html
On Tue, 22 Feb 2005 14:37:21 -0300, Adelson - Informática
<[EMAIL PROTECTED]> wrote:
>
> Por f
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 use
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
u have those tables and "pais" is a foreign key 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.
ja
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 pos
