user2957481
Reputation: 1
Setting up environment for SQL queries
I know the basic syntax of queries but otherwise I'm a beginner with SQL.
I have an SQL file (.sql) and I downloaded a couple programs (pgadmin and sql workbench).
I have no idea how to get from where I am now to actually writing queries and finding information. How do I set up so I can actually import my SQL file and start writing queries?
Upvotes: 0
Views: 69
Answers (1)
Erwin Brandstetter
Reputation: 658672
pgAdmin is the default GUI for PostgreSQL.
SQL Workbench is a free, DBMS-independent, cross-platform SQL query tool.
Either way, you need to connect to a database to actually run queries. The DBMS can either run on your local machine or you can connect to a remote server - where you need access privileges of course.
Upvotes: 1
Related Questions
- Run PostgreSQL queries from the command line
- How to configure postgresql for the first time?
- How to create production database sample for testing?
- Postgresql OVER
- SQL Schema setup
- SQL DATABASE(postgresql)
- Beginner PostgreSQL: Setting up environment for querying large pre-existing database
- custom postgresql
- How do I get started if I want to use PostgreSQL for local use?
- Simple SQL tutorial configuration difficulty