![]() Pick your database by clicking the little database icon, selecting your database, and clicking OK.Īfter you’ve picked your database, click the little SQL box, type in your query, and click Run Current. Running SQL queries against a Postgres database in TablePlus What is TablePlus TablePlus’ website describes it as: 'Modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, and Redis. ![]() The data will import, fill up your new database, and you’ll be all set! sql file you’re interested in, click OK, and click OK again to run the import.įor the mondial data, you’ll import the schema file first, and the import second. Technically this isn’t a SQL dump, its just a bunch of SQL commands, but I’m not going to complain! To import a SQL file, select File > Import > From SQL Dump. You probably want to do this with a newly created database (see previous step). Importing SQL to a new databse using TablePlus ![]() Give your database a name, and click OK to finish. Once you’re connected, you can create a new table by clicking the database button, then the +. If you’re on a mac, make sure you’ve opened Postgres.app. TablePlus is a modern intuitive application that is for managing relational and non-relational databases. If you get an error like the one below, it’s because your server isn’t running. Category Database Management System Features Query, edit and save your database easily with a native app that can run fast like a Lambo. Open up TablePlus and follow the instructions to create a new connection (right click + New > Connection).Īll of the defaults should be ok, although type in a password if you set one (on Windows it forces you to set one! Maybe you used your computer password?). TablePlus is a native application which uses Swift, Objective-C, C/C++, Perl for OSX, C for Windows and Golang for the server side. Connecting TablePlus to your Postgres server The features of TablePlus Enjoy the user interface is very customizable Very good performance in the management and organization database Volume occupancy is. You should be able to do all of your important with psql, but just in case you have weird issues - character encoding is a big one - you can use TablePlus (you downloaded this as prep already). Using TablePlus to create and query Postgres databases
0 Comments
Leave a Reply. |