Re: [SQL] linux. ossp-uuid

2010-12-21 Thread Trinath Somanchi
Hi- Do u want to add UUID support to postgresql follow this link http://raveica.comdurav.com/blog/personal/how-do-i-add-uuid-to-postgresql/ or for UUID-OSSP, here is the documentation http://www.postgresql.org/docs/8.3/static/uuid-ossp.html 2010/12/21 Николай Ижиков nizhi...@gmail.com Hi,

[SQL] data import

2010-12-21 Thread Viktor Bojović
Hi, can anyone recommend me a windows and linux free tools for importing data into postgre. Source files are CSV or excel. Thanx in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [SQL] data import

2010-12-21 Thread Pavel Stehule
Hello 2010/12/21 Viktor Bojović viktor.bojo...@gmail.com: Hi, can anyone recommend me a windows and linux free tools for importing data into postgre. Source files are CSV or excel. PostgreSQL can read a CVS files via a COPY statement. You can use a \copy metacommand too from psql Regards

[SQL] converting type and function in postgresql ?

2010-12-21 Thread Amar Dhole
Hi, I am new to postgesql. I have oracle type and function, which I needs to converting it into postgresql . I am using postgresql 9.x Type : CREATE OR REPLACE TYPE INST AS TABLE OF VARCHAR2(255) How this type can be written in postgresql ?? Oracle Function:

Re: [SQL] converting type and function in postgresql ?

2010-12-21 Thread Trinath Somanchi
Try this http://ora2pg.darold.net/ On Tue, Dec 21, 2010 at 5:03 PM, Amar Dhole adh...@tibco.com wrote: Hi, I am new to postgesql. I have oracle type and function, which I needs to converting it into postgresql . I am using postgresql 9.x Type : CREATE OR REPLACE TYPE INST

Re: [SQL] data import

2010-12-21 Thread Achilleas Mantzios
Στις Tuesday 21 December 2010 13:36:58 ο/η Pavel Stehule έγραψε: Hello 2010/12/21 Viktor Bojović viktor.bojo...@gmail.com: Hi, can anyone recommend me a windows and linux free tools for importing data into postgre. Source files are CSV or excel. Openoffice can do this job,

Re: [SQL] data import

2010-12-21 Thread Chris Ruprecht
If your file is TAB delimited, you can simply do: \copy tablename from 'some file' To get details in psql, do: psql mydatabase and at the prompt: \h copy On Dec 21, 2010, at 06:34 , Viktor Bojović wrote: Hi, can anyone recommend me a windows and linux free tools for importing data into

Re: [SQL] linux. ossp-uuid

2010-12-21 Thread Basil Bourque
As documented here: http://www.postgresql.org/docs/9.0/interactive/uuid-ossp.html Rather than assuming the host operating system has an implementation of UUID, Postgres depends on the presence of a specific implementation of UUID generation handling. This open-source implementation is called