Hi,
I recently had to do something similar: change one column from INT to BIGINT in
a table which has inherited to a depth of 3 and where some of the child tables
had millions of records.
All affected tables have to be rewritten for such a command. One consequence of
this is that you (temporar
On Fri, Nov 06, 2009 at 12:03:49PM +, Andre Lopes wrote:
> Hi,
>
> I have one oracle database and one database in sqlserver with data
> that I need to import to Postgres. Wich is the best way to import
> data to Postgres?
One way is to use DBI-Link. DBI-Link connects from PostgreSQL to the
Ivan Sergio Borgonovo wrote:
I know one of the exporting parties will be a MS SQL 2005 server, so
it would be nice if there was an easy way to import xml generated
with the FOR XML AUTO, XMLSCHEMA ('forpg').
Microsoft SQL Server has a pretty good data translation tool, it used to
be called
2009/11/6 Ivan Sergio Borgonovo :
> I need to import/export through xml files.
>
> I was looking for tools/examples/HOWTO for postgresql.
>
> Right now I still don't know the details of the requirements.
>
> I know I won't need a GUI.
>
> I know one of the exporting parties will be a MS SQL 2005 se
On 06/11/2009, at 8:48, Raimon Fernandez wrote:
I'm blocked ...
On 06/11/2009, at 6:27, John DeSoi wrote:
On Nov 5, 2009, at 12:35 PM, Raimon Fernandez wrote:
at least, my first md5 (psw+user) is the same as the pg_shadow
(wihtout the 'md5') ...
should I md5 the first md5 as I get
On 6/11/2009 3:04 PM, John R Pierce wrote:
> I don't believe anyone is building a standard package for Win64..
> The 32bit version will work just fine on 64bit windows.
... so long as you don't need 2GB (or close to it) of shared memory.
Is anybody using Pg on windows with an installation of
