Re: Reg: Data Conversion in PGSQl

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Reg: Data Conversion in PGSQl
Дата
Msg-id 4A727E72.7070307@hogranch.com
обсуждение исходный текст
Ответ на Reg: Data Conversion in PGSQl  (Rama Mohan Reddy <reddy2ramu@gmail.com>)
Список pgsql-general
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.



В списке pgsql-general по дате отправления:

Предыдущее
От: Rama Mohan Reddy
Дата:
Сообщение: Reg: Data Conversion in PGSQl
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: why is autovacuum still ongoing even if set to off ?