copyable, importable... into Excel or another postgres db?On 6/20/06, Martijn van Oosterhout <kleptog@svana.org
> wrote:On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote:> CREATE TABLE sometable AS SELECT * FROM someview;
> pg_dump -t sometable dbname> DROP TABLE sometab
CREATE TABLE sometable AS SELECT * FROM someview;
pg_dump -t sometable dbname
DROP TABLE sometable
Que? Si!On 6/20/06, Worky Workerson <[EMAIL PROTECTED]> wrote:
On 6/20/06, Aaron Koning <[EMAIL PROTECTED]> wrote:> google pg_dumpReally? What command do you use?
27;kill -9' the postmaster-- +----| Aaron Koning| Information Technologist| Prince George, BC, Canada.
+| http://datashare.gis.unbc.ca/fist/| http://datashare.gis.unbc.ca/gctp-js/
+
Are you trying to create a primary key composed of 6 fields? What is
the result you want to achieve with the constraint? If you just want
UNIQUE, NOT NULL values in a field, you can achieve that without
creating a primary key.
AaronOn 1/5/06, Daniel Kunkel <[EMAIL PROTECTED]> wrote:
HiIt makes sen
BYTEA is the easiest from my point of view. I like being able to treat
my binary data more like any other field (e.g. date, text, etc). Heres
some light reading on the BLOB/BYTEA debate:
http://search.postgresql.org/www.search?cs=utf-8&fm=on&st=20&dt=back&q=blob+bytea
AaronOn 1/5/06, Ketema Harr
This might be easier to use this SQL:
UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3);
The following might work for Cocoon (never used it):
UPDATE message_table SET status = 'A' WHERE
mid IN ();
Aaron
On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]> wrote:
Given a set of checkb
If you are using a Linux system then you can make a partition of xGB and place PGDATA there. This may work for other OS as well.
Aaron
On 12/5/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
here is a question
say i have a database and all the files(data files) indexes etc must be going to the
