Various technical articles, IT-related tutorials, software information, and development journals
Monday, July 13, 2020
Creating tables with SQL in phpPgAdmin
I'm working on setting up a PostgreSQL database hosted on Namecheap's shared hosting, which seems to only allow access through the phpPgAdmin web app. I'm testing things in a local PostgreSQL instance with a different interface and copying the table definitions to the shared server as SQL "create" commands when ready. I first tried pasting it into the box on the "SQL" tab of the database object, but phpPgAdmin seems to wrap the command in a way that makes it invalid. However, there is a small "SQL" link in the far upper right of the page that produces a new window. Arbitrary commands can be successfully run from there.
Labels:
misc
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment