logo       

Re: [GENERAL] Reg: Data Conversion in PGSQl: msg#01365

pgsql-general

Subject: Re: [GENERAL] Reg: Data Conversion in PGSQl

Rama Mohan Reddy wrote:
Hi Gurus,
My Client gave me data in .dat format for each table,
which is in postgresql in linux environment
I want to table data in windows environment

I'd suggest taking a look at those .dat files, see if they are in fact CSV or SQL or what. for instance, in a CMD prompt window...

type somefile.dat | more


just the first couple lines of one of these files should show enough. if they are some kind of raw binary data, than i dunno what you could do with them. if they are in a CSV format, you should be able to import them into almost anything, like postgres on windows, Microsoft SQL Server, Access, even Excel.



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | Mail Home | sitemap | FAQ | advertise