What you could fo is use an ETL tool. There are open source ETL tools that
are free to download.
Talend Open Studio is an open source ETL tool for data integration and
migration experts. It's easy to learn for a non-technical user. What
distinguishes Talend, when it comes to business users, is the tMap
component. It allows the user to get a graphical and functional view of
integration processes.
For more information: http://www.talend.com/
Tom Lane-2 wrote:
>
> Guy Flaherty <naoshika@gmail.com> writes:
>> On Sat, Jun 27, 2009 at 5:14 AM, Kindra Martinenko
>> <kindramart@yahoo.com>wrote:
>>> Now, yet another problem I am having is being able to launch the psql
>>> command line. It gives me a "FATAL: password authentication failed for
>>> User
>>> "Kindra".
>>>
>>> [command prompt line:\]psql U-Kindra
>>> password (trust level is set at md5): ******
>>> FATAL: password authentication failed for User "Kindra
>
>> Hmm, I have no experience with psql on windows. I am assuming you are
>> using
>> pgAdmin III on the server and not connecting to another machine. Perhaps
>> you
>> need to specify the actual database you are connecting to with psql?
>> Maybe
>> try with -D to specify the database.
>
> I'm wondering what the *actual* username is (we see three different
> renderings of it above), and whether it contains any funny characters
> that pgAdmin will quote for you but cause trouble on a shell command
> line.
>
> regards, tom lane
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>
--
View this message in context: http://www.nabble.com/Problems-importing-csv-files-tp24154431p24253387.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.