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
"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
1. Create a script that creates the tables without RI stuff like
foreign keys and triggers.
2. Import the data into the tables using COPY
3. Create the RI stuff with 'alter table' and 'create trigger'
statements
http://www.postgresql.org/docs/current/static/sql-copy.html
http://www.postgresql.or
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
15 matches
Mail list logo
