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@xxxxxxxxxxx
