Andre, thanks for the pointers. Got everything working plus after playing with phpPgAdmin found a few more features.
Much appreciated. On Wed, May 19, 2010 at 9:20 PM, Andre Garzia <an...@andregarzia.com> wrote: > Hi There Kay, > > What is the format of the data? Is it a csv file or something? Because if > it > is a text file, then you can upload the text file to your on-rev account > and > then use a SQL command such as COPY to parse and load the file. You don't > need a option in phpPgAdmin to do it, you can just write the SQL command > there. > > Check out http://www.postgresql.org/docs/8.1/static/sql-copy.html > > With this you'll be able to load a csv (or similar) file into postgresql > > It is not as straight forward as LOAD DATA INFILE but it is close. > > Cheers > andre > > > > On Wed, May 19, 2010 at 5:01 AM, Kay C Lan <lan.kc.macm...@gmail.com> > wrote: > > > I'm guessing Andre is the guru to answer this one. > > > > How does one populate a postgreSQL db on On-Rev in bulk? > > > > MySQL's phpMyAdmin gives you both an Import option and the ability to > enter > > raw SQL commands, ie LOAD DATA LOCAL INFILE, but the postgreSQL's > > phpPgAdmin > > has neither option. > > > > I'm not going to manually type in thousands of records. > > > > Thanks in advance > > > > And Ruslan, if you're reading, if On-Rev offered Valentina Free Server, > I'd > > be trying to figure out how to do this with Valentina rather than > > postgreSQL, especially as I'd assume it would be as easy as using > Valentina > > Studio's Connect to... Server option. > > _______________________________________________ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > -- > http://www.andregarzia.com All We Do Is Code. > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution