CODEWITHSUNDEEP
postgresqlpostgresql-9.1
jay
jay

Reputation: 1

Selecting 2 tables in the same editor

In SQL I can write 2 separate SELECT statements and execute them at the same time, such as:

SELECT * FROM Table_Name

SELECT * FROM Another_Table

Is it possible to do this in PostgreSQL?

Upvotes: 0

Views: 87

Answers (1)

Brian.D.Myers
Brian.D.Myers

Reputation: 2518

It sounds to me like you're really asking a PGAdmin question. In SQL Server's query analyzer / Enterprise Manager if you execute two select statements, two result sets will be displayed in the output area.

PGAdmin doesn't do this; you need two separate query windows to see both result sets. I know of no other free GUI admin tool for PostgreSQL. Maybe someone else will.

EDIT: I've recently started using Squirrel-SQL and DBeaver. Either of these may be more what you're looking for. I prefer DBeaver myself.

Brian

Upvotes: 1

Related Questions