Обсуждение: data import
Hi,
can anyone recommend me a windows and linux free tools for importing data into postgre.
Source files are CSV or excel.
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
Hello 2010/12/21 Viktor Bojović <viktor.bojovic@gmail.com>: > Hi, > > can anyone recommend me a windows and linux free tools for importing data > into postgre. > Source files are CSV or excel. PostgreSQL can read a CVS files via a COPY statement. You can use a \copy metacommand too from psql Regards Pavel Stehule > Thanx in advance > -- > --------------------------------------- > Viktor Bojović > --------------------------------------- > Wherever I go, Murphy goes with me >
Στις Tuesday 21 December 2010 13:36:58 ο/η Pavel Stehule έγραψε: > Hello > > 2010/12/21 Viktor Bojović <viktor.bojovic@gmail.com>: > > Hi, > > > > can anyone recommend me a windows and linux free tools for importing data > > into postgre. > > Source files are CSV or excel. > Openoffice can do this job, populating a table from an excel data source, but every time i do it (which is not often) it is like reinventing the wheel again. The way to do it, IIRC, is to "create" a database based on your existing excel data source. After that you can copy data from this "excel-powered" database to your normal pgsql database, fairly easily. It is easy actually, just not so straight forward as most people would want. > PostgreSQL can read a CVS files via a COPY statement. You can use a > \copy metacommand too from psql > > Regards > > Pavel Stehule > > > Thanx in advance > > -- > > --------------------------------------- > > Viktor Bojović > > --------------------------------------- > > Wherever I go, Murphy goes with me > > > -- Achilleas Mantzios
If your file is TAB delimited, you can simply do: \copy tablename from 'some file' To get details in psql, do: psql mydatabase and at the prompt: \h copy On Dec 21, 2010, at 06:34 , Viktor Bojović wrote: > Hi, > > can anyone recommend me a windows and linux free tools for importing data into postgre. > Source files are CSV or excel. > > Thanx in advance > -- > --------------------------------------- > Viktor Bojović > --------------------------------------- > Wherever I go, Murphy goes with me
Thanx Chris.
Also i want to thank Achilleas and Pavel for help
On Tue, Dec 21, 2010 at 5:18 PM, Chris Ruprecht <chris@ruprecht.org> wrote:
If your file is TAB delimited, you can simply do:
\copy tablename from 'some file'
To get details in psql, do:
psql mydatabase
and at the prompt:
\h copy
On Dec 21, 2010, at 06:34 , Viktor Bojović wrote:
> Hi,
>
> can anyone recommend me a windows and linux free tools for importing data into postgre.
> Source files are CSV or excel.
>
> Thanx in advance
> --
> ---------------------------------------
> Viktor Bojović
> ---------------------------------------
> Wherever I go, Murphy goes with me--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me