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 "
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
> i
Στις Tuesday 21 December 2010 13:36:58 ο/η Pavel Stehule έγραψε:
> Hello
>
> 2010/12/21 Viktor Bojović :
> > 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, populating a table
Try this
http://ora2pg.darold.net/
On Tue, Dec 21, 2010 at 5:03 PM, Amar Dhole 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
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:
CREAT
Hello
2010/12/21 Viktor Bojović :
> 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
Pavel Stehule
> Tha
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
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 Николай Ижиков
> Hi, guys.
>
> I have linu
Hi, guys.
I have linux server. Package uuid installed
I build and install postgresql from source with --with-ossp-uuid flag.
After installation I try to execute:
===
create or replace function uuid_generate_v1() returns uuid as
'$libdir/uuid-ossp', 'uuid_generate_v1' volatile strict languag
