[ADMIN] Using COPY for bulk upload in a table with sequence field

[Gautam Saha]

Hi:
Can I use COPY command to upload a flat text file into a PG table where
the PK  column (item_id) is Serial type.
The table is an existing table with data and I want to
insert new rows from the flat file. The sequence already defined for 
this column.

If I do not have the item_id data in my flat file, is it going to get the
id from nextval from the sequence?
Any help is appreciated.
Gautam

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

[ADMIN] ER diagram tool for PostgresSQL7.3

[Gautam Saha]

Hi:

Is there a ER diagram tool someone can recommend for PostgreSQL?
I should be able to create ER diagram from existing database also 
(reverse engineering).
Any open source product would be ideal.

Thanks,

Gautam



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

[ADMIN] data format problem for upgrede from 7.1->7.3

[Gautam Saha]

Hi:

I just upgraded from 7.1->7.3, but did not take a data back up.
Now when i try to start the posrGreSQL server I get the message:
An old version of the database format was found.\nYou need to upgrade 
the data format before using PostgreSQL.\nSee (Your System's 
documentation directory)/postgresql-7.3/README.rpm-dist for more 
information.

There is not much info on format change in the Docs.

Any idea what might be the resolution here?

Thanks,

Gautam

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html