Re: insert data from an microsoft excel

On Feb 16, 2005, at 6:16 AM, Nageshwar Rao wrote:

> Is there is way to load data from as Microsoft excel into database
> tables in postgresql7.4.x


Sure. Export the data into a CSV file. Then import it using psql and
the \COPY command.

http://www.postgresql.org/docs/8.0/interactive/app-psql.html
http://www.postgresql.org/docs/8.0/interactive/sql-copy.html


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL