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 <[email protected]> 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 > [email protected] > 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
