[SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
Kay C Lan
lan.kc.macmail at gmail.com
Sat May 22 04:17:04 CDT 2010
thanks for the pointers. Got everything working plus after playing with
phpPgAdmin found a few more features.
On Wed, May 19, 2010 at 9:20 PM, Andre Garzia <andre at andregarzia.com> wrote:
> Hi There Kay,
> What is the format of the data? Is it a csv file or something? Because if
> is a text file, then you can upload the text file to your on-rev account
> 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
> 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.
> On Wed, May 19, 2010 at 5:01 AM, Kay C Lan <lan.kc.macmail at gmail.com>
> > 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
> > 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,
> > 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
> > Studio's Connect to... Server option.
> > _______________________________________________
> > use-revolution mailing list
> > use-revolution at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode