pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
I have a Question
5+ messages / 4 participants
[nested] [flat]

* I have a Question
@ 2002-01-08 15:13 jairo emilio ortiz romero <jairoortiz_55@yahoo.com>
  0 siblings, 0 replies; 5+ messages in thread

From: jairo emilio ortiz romero @ 2002-01-08 15:13 UTC (permalink / raw)
  To: pgsql-admin

help me please, I am using Postgresql, I want to know
if exists a limit in the number of rows to create a
function. I created a function using pgaccess, but
when I try to see it using PgAdmin, I can not see all
the lines I wrote. Thank you for your answers. I am
writting from Colombia (I am still learning english)

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* I have a question?
@ 2006-04-07 04:35 cruise0078 <cruise0078@163.com>
  2006-04-08 07:11 ` Re: I have a question? Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-04-09 21:37 ` Re: I have a question? Milen Dzhumerov <gamehack@gmail.com>
  0 siblings, 2 replies; 5+ messages in thread

From: cruise0078 @ 2006-04-07 04:35 UTC (permalink / raw)
  To: pgsql-admin

Dear Firends:
        Now I want to migrate all data from  MySQL to PostGRESQL.There are hands of tables in MySQL.I  want to to know if there are some tools to help me to do that.Also I want to know the key point to finish that process and how much time it may take!  Very Thanks!
                                                                                                                                                         cruise dong

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: I have a question?
  2006-04-07 04:35 I have a question? cruise0078 <cruise0078@163.com>
@ 2006-04-08 07:11 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
  1 sibling, 0 replies; 5+ messages in thread

From: Andy Shellam @ 2006-04-08 07:11 UTC (permalink / raw)
  To: 'cruise0078' <cruise0078@163.com>; +Cc: pgsql-admin

Hmm,
 
Not sure about an easy way to do this using Postgres's built-in tools - try
www.sqlmanager.net - they have lots of export tools to export data from one
system to another, and they do 30-day trials of most of them.
 
Andy

  _____  

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.
org] On Behalf Of cruise0078
Sent: Friday, 07 April, 2006 5:35 am
To: pgsql-admin@postgresql.org
Subject: [ADMIN] I have a question?


Dear Firends:
Now I want to migrate all data from MySQL to PostGRESQL.There are hands of
tables in MySQL.I want to to know if there are some tools to help me to do
that.Also I want to know the key point to finish that process and how much
time it may take! Very Thanks!
cruise dong







你 知 道 2006 年 最 火 爆 的 电 子 邮 箱 吗 ? 
多 达 1.1 亿 中 国 人 选 择 网 易  <http://www.126.com/help/126fab.htm; 2000
兆 免 费 邮 箱 , 抢 注 再 得 280 兆 超 大 网 盘
!DSPAM:14,4436b1ad33691062811647! 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: I have a question?
  2006-04-07 04:35 I have a question? cruise0078 <cruise0078@163.com>
@ 2006-04-09 21:37 ` Milen Dzhumerov <gamehack@gmail.com>
  2006-04-10 09:00   ` Re: I have a question? Andy Shellam <andy.shellam@mailnetwork.co.uk>
  1 sibling, 1 reply; 5+ messages in thread

From: Milen Dzhumerov @ 2006-04-09 21:37 UTC (permalink / raw)
  To: pgsql-admin

cruise0078 wrote:
> Dear Firends:
> Now I want to migrate all data from MySQL to PostGRESQL.There are
> hands of tables in MySQL.I want to to know if there are some tools to
> help me to do that.Also I want to know the key point to finish that
> process and how much time it may take! Very Thanks!
> cruise dong
>
>
>
>
>
>
> 你 知 道 2006 年 最 火 爆 的 电子 邮 箱 吗 ?
> 多 达 1.1 亿 中 国人 选 择 网 易 2000 兆 免 费 邮 箱 , 抢 注 再 得
> 280 兆 超 大 网 盘 <http://www.126.com/help/126fab.htm;
You can use phpMyAdmin's functionality to export all the data to
standard SQL files (.sql) and then use these to put the data back into
PostgreSQL.

Regards,
gamehack



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: I have a question?
  2006-04-07 04:35 I have a question? cruise0078 <cruise0078@163.com>
  2006-04-09 21:37 ` Re: I have a question? Milen Dzhumerov <gamehack@gmail.com>
@ 2006-04-10 09:00   ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
  0 siblings, 0 replies; 5+ messages in thread

From: Andy Shellam @ 2006-04-10 09:00 UTC (permalink / raw)
  To: 'Milen Dzhumerov' <gamehack@gmail.com>; +Cc: pgsql-admin

mySQL uses a weird CREATE TABLE syntax (with added options like table engine
type etc) that Postgres errors on -  so some manual editing of the SQL dump
will be necessary.  An export tool is probably the best way to go, that'll
read data from one ODBC driver and write it to another.  www.sqlmanager.net
has some useful tools like that, and for a one-off job most of them come as
30-day trials.

Andy

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.
org] On Behalf Of Milen Dzhumerov
Sent: Sunday, 09 April, 2006 10:37 pm
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] I have a question?

cruise0078 wrote:
> Dear Firends:
> Now I want to migrate all data from MySQL to PostGRESQL.There are
> hands of tables in MySQL.I want to to know if there are some tools to
> help me to do that.Also I want to know the key point to finish that
> process and how much time it may take! Very Thanks!
> cruise dong
>
>
>
>
>
>
> 你 知 道 2006 年 最 火 爆 的 电子 邮 箱 吗 ?
> 多 达 1.1 亿 中 国人 选 择 网 易 2000 兆 免 费 邮 箱 , 抢 注 再 得
> 280 兆 超 大 网 盘 <http://www.126.com/help/126fab.htm;
You can use phpMyAdmin's functionality to export all the data to
standard SQL files (.sql) and then use these to put the data back into
PostgreSQL.

Regards,
gamehack

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

!DSPAM:14,44397f0d33691259350361!







^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-04-10 09:00 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-08 15:13 I have a Question jairo emilio ortiz romero <jairoortiz_55@yahoo.com>
2006-04-07 04:35 I have a question? cruise0078 <cruise0078@163.com>
2006-04-08 07:11 ` Re: I have a question? Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-04-09 21:37 ` Re: I have a question? Milen Dzhumerov <gamehack@gmail.com>
2006-04-10 09:00   ` Re: I have a question? Andy Shellam <andy.shellam@mailnetwork.co.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox