Heyho!
On Sunday 27 June 2010 08.22:09 RP Khare wrote:
> I downloaded PostgreSQL plus advanced server from EnterpriseDB website.
> Should I go with the original community PGSQL edition or EnterpriseDB
> edition?
If you work on a Linux/BSD/... OS distribution with a sane package manager,
I always
John R Pierce wrote:
On 06/26/10 11:22 PM, RP Khare wrote:
I downloaded PostgreSQL plus advanced server from EnterpriseDB
website. Should I go with the original community PGSQL edition or
EnterpriseDB edition?
thats entirely up to your preferences and needs.Personally, I think
that the s
On 06/26/10 11:22 PM, RP Khare wrote:
I downloaded PostgreSQL plus advanced server from EnterpriseDB
website. Should I go with the original community PGSQL edition or
EnterpriseDB edition?
thats entirely up to your preferences and needs.Personally, I think
that the standard PostgreSQL wou
On Sun, Jun 27, 2010 at 00:22, RP Khare
wrote:
> I want to migrate a production MySQL database to PostgreSQL. Is there any
> free tool that works effectively?
I'd start here:
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
--
Sent via pgsql-general mailing li
I want to migrate a production MySQL database to PostgreSQL. Is there any free
tool that works effectively?
I downloaded PostgreSQL plus advanced server from EnterpriseDB website. Should
I go with the original community PGSQL edition or EnterpriseDB edition?
Regards,
Rohit Prakash
"Dave Lee" <[EMAIL PROTECTED]> writes:
> I've read src/backend/utils/fmgr/README and it states that returning
> NULL is just a matter of setting isnull to true in the
> FunctionCallInfo struct, and provides a convenience macro,
> PG_RETURN_NULL. But then, in InputFunctionCall, I presume you're
> re
On Wed, Jun 18, 2008 at 3:25 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> There isn't any really nice way to do that :-(. You could put a wrapper
> function around int4in but it would not help, because the internal API
> for datatype input functions doesn't support having them return NULL
> (see Inpu
"Dave Lee" <[EMAIL PROTECTED]> writes:
> I see. Other than directly modifying int4in (is this the one?), is
> there a way to plug-in our modified empty string handling logic? I'm
> picturing a scenario where we write write a wrapper function that
> tests for empty strings and returns NULL, else jus
On Wed, Jun 18, 2008 at 12:39 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> None. There is no type coercion there --- what that is really
> specifying is invocation of the int data type's input function
> on the given string.
I thought that something like this may be this was the case.
> I don't thi
"Dave Lee" <[EMAIL PROTECTED]> writes:
> and I notice that there isn't any rows specified for converting
> varchar or text to int. Which raises the question, if I run:
> SELECT '123'::int;
> What conversion is actually happening here?
None. There is no type coercion there --- what that is reall
Hi,
We have an existing (PHP) code base that is being converted to use
PostgreSQL from MySQL. In most places, our insert and update
statements are formed using single quoted values, and when there is no
value, the empty string is being passed in. PostgreSQL objects to
empty strings for certain col
ge-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Junaili Lie
Sent: Wednesday, December 22, 2004 5:04 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] migrating from mysql
Hi everyone,
I am new to postgresql.
I am planning to migrate our current database (mysql) to posgresql. I
Hi everyone,
I am new to postgresql.
I am planning to migrate our current database (mysql) to posgresql. I
am currently having difficulties dealing with the order of the tables
that is created.
Here is what I do:
1. I use myqsldump to get the schema and data.
2. I use my2pg and a java utility I cre
On Wed, 24 May 2000 14:26:32 -0500 "Ross J. Reedstrom" wrote:
> Actually, it's "\d tablename". The rest is right, though.
Teach me to try to tidy things up before posting won't it?
Thanks!
Giles (sigh, time for coffee)
Joe Karthauser wrote:
>
> Hi there,
>
> I'm migrating from MySQL to PostgreSQL and I was wondering whether someone
> could help me match some datatypes.
I'm trying to learn PostgreSQL myself. They say there's no better way
to learn than to teach, so here goes...
> Firstly MySQL has a 'timesta
On Thu, May 25, 2000 at 04:58:48AM +1000, Giles Lean wrote:
>
> On Mon, 15 May 2000 23:04:48 +0100 Joe Karthauser wrote:
>
> > And last but not least I'm used to using the 'desc tablename' sql command
> > to show the structure of a table within MySQL. How do I do the same in
> > PostgreSQL.
>
On Mon, 15 May 2000 23:04:48 +0100 Joe Karthauser wrote:
> And last but not least I'm used to using the 'desc tablename' sql command
> to show the structure of a table within MySQL. How do I do the same in
> PostgreSQL.
In psql "\i tablename". Check out \? or the documentation for all the
di
> Hi there,
>
> I'm migrating from MySQL to PostgreSQL and I was wondering whether someone
> could help me match some datatypes.
I'm also migrating, and would appreciate any thoughts on how to do
it. Spesifically, if there could be any problems with functions not
supported on the PostgreSQL and
18 matches
Mail list logo
