importing database in postgres

gnurich · 01-15-2010, 11:54 PM

i have made a schema in postgres in which i want to import data from MS Excel sheet.Like in PHP there's no direct option of importing tables in database.plz suggest.

Another problem that i am facing is in making an audit trail of a table where i am trying to get primary key name and primary key value.i am unable to build the function properly.plz guide and if possible with the code.

emi_ramo · 01-16-2010, 08:19 AM

For DB importing:

Save Excel table with CSV format, with tabs instead of commas
Edit the file with a text editor

Add a line before the data:

Code:

COPY TableName (col1,col2,etc) FROM stdin;

Add a line after the data:
Code:
```
\.
```
(backslash dot)
Import the table as usual:
Code:
```
psql -U USER -f FILE DATABASE
```