Subject: Re: [GENERAL] [NOVICE]
Question About Aggregate Functions
On 9/13/06, Brandon
Aiken <[EMAIL PROTECTED]>
wrote:
Ah, I did not know what was in your fields, so I did not
assume they were Boolean values. It looked to me like you were trying to
use IS TRUE to substitute for t
On 9/13/06, Brandon Aiken <[EMAIL PROTECTED]> wrote:
Ah, I did not know what was in your
fields, so I did not assume they were Boolean values. It looked to me
like you were trying to use IS TRUE to substitute for the lack of a GROUP BY,
so I didn't know what to do.That was in the fi
Ah, I did not know what was in your
fields, so I did not assume they were Boolean values. It looked to me
like you were trying to use IS TRUE to substitute for the lack of a GROUP BY,
so I didn’t know what to do.
Yes, count() will include all non-NULL
values. Sorry if I sounded unclea
[EMAIL PROTECTED] (Michael Romagnoli) writes:
> What kind of command would I run if I wanted to copy an entire table
> (along with renaming it, and, of course, all data from the first table
> -
> some of which is binary)?
SELECT * INTO newtable FROM oldtable;
Note that this doesn't construct ind
create database newdb template olddb;
works as well.
-Chris
On Tuesday 01 March 2005 05:08 pm, javier wilson wrote:
> 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 th
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
Sean Davis wrote:
On Mar 1, 2005, at 4:23 PM, Michael Romagnoli wrote:
I am new to postgresql, having previously worked with mysql mostly.
What kind of command would I run if I wanted to copy an entire table
(along with renaming it, and, of course, all data from the first table
- some of which is
On Mar 1, 2005, at 4:23 PM, Michael Romagnoli wrote:
I am new to postgresql, having previously worked with mysql mostly.
What kind of command would I run if I wanted to copy an entire table
(along with renaming it, and, of course, all data from the first table
- some of which is binary)?
Thanks,
Sorry, I meant to ask about copying databases, not tables (including all
data in the database as per below).
Thanks,
-Mike
Michael Romagnoli wrote:
I am new to postgresql, having previously worked with mysql mostly.
What kind of command would I run if I wanted to copy an entire table
(along with
I am new to postgresql, having previously worked with mysql mostly.
What kind of command would I run if I wanted to copy an entire table
(along with renaming it, and, of course, all data from the first table -
some of which is binary)?
Thanks,
-Mike
---(end of broadcast)-
10 matches
Mail list logo