Barry,
Per the COPY documentation:
*COPY moves data between PostgreSQL tables and standard file-system files. COPY
TO copies the contents of a table to a file, while COPY FROM copies data
from a file to a table (appending the data to whatever is in the table
already). *
...So it's not destructiv
Steve,
Here's your problem and its solution as I understand it:
-- Given an example table like this (data isn't too important -- just the
sequencing)
create table meh
(
idserial primary key
, word varchar(10)
);
-- Populate it with data
insert into meh (word) values
('on
our dependent tables. You can expect
performance to suffer if the dependent tables are large, but at least you
don't lose referential integrity.
Dave
On Thu, Jun 19, 2008 at 7:07 PM, David Spadea <[EMAIL PROTECTED]>
wrote:
> Steve,
>
> Here's your problem and its so
> Christine,
>>
>> What happens if you run it from a command prompt? (Start -> Run -> "cmd")Â
>> Can you please post the command line you're using and its output?
>>
>> Note that you may need to provide a full path to initdb if it isn't
Hi all,
I'm looking to do some reporting on tablespace usage, and wanted to be able
to determine how much of the space a table physically occupies is actually
in use.
1. I know I can get n_live_tup and n_dead_tup from pg_stat_all_tables, but I
don't think that really answers the question entirely
1". That way you can remove the loop altogether and save
lots of processing time.
--
David Spadea
On Thu, Jul 24, 2008 at 5:41 AM, admin <[EMAIL PROTECTED]> wrote:
> First, thanks to everyone who responded to my newbie questions yesterday,
> all clear now.
>
> I spen
08-02-01'::timestamp - '2008-01-01'::timestamp AS '1 month'
>
> Here I want '1 month' and not '31 days' as answer.
>
> How can I do this?
>
> Regards,
> Gerhard
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFJFVgNa8fhU24j2fkRAq0ZAJ925CHwchm/kZCwTTDcZF/QVXAlewCeMYGL
> h3y0pxtiOiDV7pExYiEcSZ0=
> =84G4
> -END PGP SIGNATURE-
>
>
--
David Spadea
President
Spadea Enterprises, Inc
http://www.spadea.net
