[SQL] Re: Auto incrementing an integer

2001-05-16 Thread 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(

[SQL] Auto incrementing an integer

2001-05-14 Thread 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: Informix->PostgreSQL database convertion

2001-05-12 Thread 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 yo

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

2001-05-11 Thread 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] Informix->PostgreSQL database convertion

2001-05-11 Thread 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: Informix->PostgreSQL database convertion

2001-05-11 Thread 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 li