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

2005-01-18 Thread 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 fla

[ADMIN] ER diagram tool for PostgresSQL7.3

2003-11-10 Thread 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:

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

2003-11-04 Thread 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)/postgre