Re: running a batch script

On 6/19/20 8:30 AM, Richard Bernstein wrote:
> I am trying to test out a package called phpGrid and I need to run 
> through its tutorial. But there are some "kinks". I am developing on my 
> ubuntu laptop in a docker container. The postgresql I need to test-to is 
> AWS RDS Postgresql.  I have an account and Server and can access it with 
> pgAdmin. The install instructs for phpGrid asked me to modify conf.php. 
> In my case I used app.conf which sets up the virtual host. I restarted 
> the containers. Next the tutorial wants me to "run" an sql batch script 
> to create the table. The batch script is pretty mySQL centric. I am 
> attaching it.
> 
> Can I run this from pgAdmin the same way I would with phpMyAdmin in 
> mySQL? Do I need to modify the script for postgresql? Is this the 

Yes. This script is definitely MySQL specific. Some examples:

USE `sampledb`;

CREATE TABLE `changes` (
   `n_r` int(11) NOT NULL AUTO_INCREMENT, <--That would be SERIAL or 
IDENTITY.

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; <--No go.

UNLOCK TABLES;

and so on.



> easiest way to create this sample table? I have one table that I have 

Take a look at:

https://pgloader.readthedocs.io/en/latest/ref/mysql.html

> created in pgAdmin called called imagesdatabase and I'd prefer not to 
> break that since it took some time with AWS support to get that going.


-- 
Adrian Klaver
adrian.klaver@aklaver.com