How to avoid pre-moderation of my comments?
Is it possible to import .txt files in PostgreySQL
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > PostgreSQL database development > Is it possible to import .txt files in PostgreySQL 1 October 2002 22:08:29
  Recent blog posts: 
How to make a Christmas photo…
Every Christmas people take a off from their busy schedule. This is the time they can enjoy with their…

Car web design, motorbike…
If you are looking for Car website design, Auto web design, bike web design, or anything similar our…

The Best Video Converter-a…
iOrgSoft Inc. has released the powerful Video Converter - iOrgSoft Video Converter 1.6.0, the latest…

Photo DVD Maker New Website…
AnvSoft Inc., the multimedia software developer, unveils a new website…

How to rip DVD movie, convert…
It is no doubt that PSP is an excellent game player. However, it is not playing games all the time; you…

World’s Most Unusual Christmas…
This Christmas, don’t go with that ho-hum, run-of-the-tree-far­­m tree your family always gets…

Facebook account cracker
facebook account cracker (50 GBP) Before you're told what this tool does, it's worth noting that…

BlackBerry Storm review…
As BlackBerry fans, you can’t miss the BlackBerry Storm. At Nov 6th, 2008, the word on the street is…

Review on Any DVD Cloner
Have you ever had a DVD Movie collection broken or lost? Have you ever wanted to backup movies but…

All recruitment agencys come…
What is RCCSS? RCCSS is a new unique peice of software which will scan millions of major sites and…

  They have birthday today: 
Luvila
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
plpgsql - Insert from a record…
Dear Postgresql experts, I'm writing a simple plpgsql function that selects a row from a table…

calling a pl/pgsql function…
Hello, i am tryin to pass an array like argument to a pl/pgsql function but i can not find the correct…

PgDatabase, on heap…
I am having a problem constructing a PgDatabase object. If I create the object on the stack (as a var…

Backup and restore through JDBC
Hello List I am trying to develop, a API to carry through backup and restore through JDBC. I think that…
  Recent forum topics: 
Cookies/Remeber password
Hi folks, I'm trying to do a simple username/password login for new members in my website (both are…

Should a closure-in-a-string…
I expected this to DWIM today: $ perl6 -e 'my $cl = { "$^name upcased becomes {$^name.uc}" };…

[perl #60674] sign($x) always…
On Wed Nov 19 07:35:48 2008, masak wrote: I'd argue that it's a Failure. If you care about complex…
  Recent forum comments:
RE: [RELEASE CANDIDATE]…
Steve Hay wrote: This is hopefully now fixed with r719313. Sorry it took so long!!! [I haven't been…

RE: [perl #60674] sign($x) always…
HaloO, Moritz Lenz via RT wrote: This is a bit drastic. If one computes in the complex domain a…

RE: Stop sql Injection attacks and…
On Wed, 19 Nov 2008 12:55:13 +0100 (GMT+01:00), Deviloper <deviloper@slived.n­et> wrote…

RE: IBM Application Server Crash…
…

RE: Problem with uploader
Matthew Whipple wrote: If the open failed then wouldn't the die kick in and at least say something in…

RE: [JCA/JBoss] - getOutputStream()…
Put Your Java Code in Servlet. It will work fine Try to avoid scriplet in jsp

RE: Re: Please Help Advanse Search…
Hello Old Pedant, Thank you Once again for the effort taken to Help. It seems to be a Error that…

RE: Re: Please Help Advanse Search…
Hello Bob Barrows, and Old Pedant, I thank you so much for the response I am sorry for the late reply…

RE: how to retrieve CheckBox value…
Old Pedant wrote: This seems to contradict your earlier argument that Request("foo") is the…

RE: how to retrieve CheckBox value…
"magix" <magix@asia.com> wrote in message news:48ad9aed$1_2@n­ews.tm.net.my…
  Moderators:
 Administrator
 Protorioris

Is it possible to import .txt files in PostgreySQL

Murali Mohan Kasetty 1 October 2002 22:08:29
 Hi All,

Is it possible to import data from .txt files into PostgreySQL
7.1.3. If so , How do I do it?

Any help would be greatly appreciated.


Thanks in advance,
Murali



-------------------­--------(end of broadcast)---------­------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresq­l.org so that your
message can get through to the mailing list cleanly
Add comment
Martijn van Oosterhout 1 October 2002 15:16:51 [ permanent link ]
 On Tue, Oct 01, 2002 at 05:40:42PM +0530, Murali Mohan Kasetty wrote:> Hi All,>
Is it possible to import data from .txt files into PostgreySQL> 7.1.3. If so , How do I do it?>
Any help would be greatly appreciated.

\copy in psql can copy delimited files. There is a similar facility using
the pq library.

--
Martijn van Oosterhout <kleptog@svana.org>­ http://svana.org/kl­eptog/> There are 10 kinds of people in the world, those that can do binary> arithmetic and those that can't.

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

http://archives.pos­tgresql.org

Add comment
Jeff Eckermann 1 October 2002 22:02:45 [ permanent link ]
 
--- Martijn van Oosterhout <kleptog@svana.org>­ wrote:> On Tue, Oct 01, 2002 at 05:40:42PM +0530, Murali> Mohan Kasetty wrote:> > Hi All,> >
Is it possible to import data from .txt files> into PostgreySQL> > 7.1.3. If so , How do I do it?> >
Any help would be greatly appreciated.>
\copy in psql can copy delimited files. There is a> similar facility using> the pq library.>
One small point: if your .txt file originated on a
Windows machine, the lines will be terminated by
carriage return/line feed pairs. Since unix-type
operating systems only recognize the line feed as a
line terminator, the carriage return would be included
in your data. This is almost certainly not what you
want. You would need to delete those carriage returns
before importing your data. Something like:
perl -pi -e 's/\r$//' <datafile>

___________________­____________________­___________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.co­m

-------------------­--------(end of broadcast)---------­------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHer­e" to majordomo@postgresq­l.org)

Add comment
Walt Weaver 1 October 2002 22:08:29 [ permanent link ]
 Or use dos2unix...

--Walt

-----Original Message-----
From: Jeff Eckermann [mailto:jeff_eckermann@yahoo.com]
Sent: Tuesday, October 01, 2002 1:03 PM
To: Martijn van Oosterhout; Murali Mohan Kasetty
Cc: pgsql-general@postg­resql.org
Subject: Re: [GENERAL] Is it possible to import .txt files in
PostgreySQL



--- Martijn van Oosterhout <kleptog@svana.org>­ wrote:> On Tue, Oct 01, 2002 at 05:40:42PM +0530, Murali> Mohan Kasetty wrote:> > Hi All,> >
Is it possible to import data from .txt files> into PostgreySQL> > 7.1.3. If so , How do I do it?> >
Any help would be greatly appreciated.>
\copy in psql can copy delimited files. There is a> similar facility using> the pq library.>
One small point: if your .txt file originated on a
Windows machine, the lines will be terminated by
carriage return/line feed pairs. Since unix-type
operating systems only recognize the line feed as a
line terminator, the carriage return would be included
in your data. This is almost certainly not what you
want. You would need to delete those carriage returns
before importing your data. Something like:
perl -pi -e 's/\r$//' <datafile>

___________________­____________________­___________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.co­m

-------------------­--------(end of broadcast)---------­------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHer­e" to majordomo@postgresq­l.org)

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

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > PostgreSQL database development > Is it possible to import .txt files in PostgreySQL 1 October 2002 22:08:29
see also:
removing duplicate validation messages…
Console interface
Struts form tag attribute…
пройди тесты:
see also:
Trifle Matters
Change Means...
Let's Join the Army
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .