Import text field

Carlos Jacobs wrote:

Hi:
I have a MS Access database with tables containing TEXT fields.
I need import that info in a postgres 7 table.
How to do it?
If I use copy from, dont work.

I have a perl program which will import this sort of multi-line CSV data
that is not handled by the COPY ... DELIMITER ... sort of mechanism in
PostgreSQL.

E-mail me privately if you want a copy.

Regards,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Hello everybody

First of all I wold like to thank you in advance because I am sure
that I would get my answer immediately.

Well I want to use nested select statements ,is it possible.
Is there any counterpart for 'Sysdate from dual' as in Oracle

with Regards

Sanjay Arora

At 08:31 PM 11/29/00 +0530, Sanjay Arora wrote:

Well I want to use nested select statements ,is it possible.

In PG 7.0 you can use subselects in the "where" clause.

Is there any counterpart for 'Sysdate from dual' as in Oracle

You don't need "dual", just "select now()" will work.

If you're porting Oracle code, you can make life a lot easier by
defining some stuff:

create function sysdate() returns datetime as '
begin
return ''now'';
end;' language 'plpgsql';

create view dual as select sysdate();

Then "select sysdate from dual", "select (any expression) from dual", etc all do what
you'd expect.

- Don Baccus, Portland OR <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.