[SQL] Re: Informix->PostgreSQL database convertion

[Sylte]

It is convertion of the data, not the application...



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[SQL] Informix->PostgreSQL database convertion

[Sylte]

Howto? Are there tools or is it just a lot of hard work with a lot of PHP?
Some examples or site-links will be appreciated :O)

Thanks
- Sylte



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Re: How to store gif or jpeg? Thanks!

[Sylte]

> src/interfaces/jdbc/example/ImageViewer.java

Somewhere on the internet Please be more specific



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] Re: Informix->PostgreSQL database convertion

[Sylte]

How is the SQL command UNLOAD (informix) used to extract both data and
database architecture?

Is it able to create a file of SQL statements like when using postgresql's
command  "pg_dump -f outputfile mydb"



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

[SQL] Auto incrementing an integer

[Sylte]

How do I construct a datatype that autoincrement in postgreSQL?

Thanks
Sylte




---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] Re: Auto incrementing an integer

[Sylte]

Thanks MartínI found this http://dis.lib.muohio.edu/code/entry.html?ID=3

Creating an Autoincrement field in Postgresql

  postgres does this a little differently; the "serial" type creates an
integer column, and a sequence used to increment this column.

try this:

create table table_name(
control serial,
another_column text,
primary key(control)
);

results in this:
Table= table_name
+--+--+-
--+
|  Field   |  Type|
Length|
+--+--+-
--+
| control  | int4 not null default nextval('" |
4 |
| another_column   | text |
var |
+--+--+-
--+
Index:table_name_pkey





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