[GENERAL] CSV options in COPY

[hjenkins]

Hello, all,

On the subject of the COPY command
(http://www.postgresql.org/docs/current/interactive/sql-copy.html), is it
the case that the HEADER, QUOTE, escape, FORCE QUOTE, and FORCE NOT NULL
options can only be used in CSV mode? If so, why? A tab-delimited table
with a header line and quoted strings seems a perfectly reasonable format.
If not, how?

Regards,
Hazel Jenkins



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] combining semi-duplicate rows

[hjenkins]

Hello,

I have a table of rows which partially duplicate one another and need to
be merged and moved into a table with a primary key.

As an additional complication, some of the duplicates contain different
information, ex.:
schema1.datatable: key1  None None 34
schema2.datatable: key1  127None

desired result:
schema1.datatable: key1  1234

I looked for a specific function that would do this sort of merge and
failed. So I tried:

UPDATE schema1.datatable SET schema1.datatable.field1 =
schema2.datatable.field1 FROM schema2.datatable
WHERE schema2.datatable.keyfield = schema1.datatable.keyfield
AND schema1.datatable.field1 = None;

Which is suboptimal because I'd need a command for each field, but it
would be a start. However, the schema names are not recognised. I get
error messages to the effect that cross-database references are not
implemented or relation schema1/2 does not exist.Even the much simpler

SELECT DISTINCT schema2.datatable INTO schema1.datatable;

...gives me these messages. Qualifying right up to the database level
produces improper qualified name (too many dotted names).

I'm pretty sure that this isn't a capitalization/quoting problem as
described in the FAQ. Is it not possible to use these functions between
schemas? Or am I misusing the functions in a more basic way?

The problem is somewhat similar to this one:
http://archives.postgresql.org/pgsql-sql/2007-02/msg00055.php

Namely,

Regards,
H.Jenkins


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] spreadsheet interface

[hjenkins]

Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?





---(end of broadcast)---
TIP 6: explain analyze is your friend

[GENERAL] comparing rows

[hjenkins]

Hello, all,

I would like to take a timeseries of data and extract the rows of data
flanking the gaps in it. So I need to compare timestamps from two adjacent
rows, and determine if the interval is greater than the standard sampling
interval.

Thanks for any help.

Regards,
H. Jenkins


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings