Hot answers tagged


Please note the following commands: \list or \l: list all databases \dt: list all tables in the current database You will never see tables in other databases, these tables aren't visible. You have to connect to the correct database to see its tables (and other objects). To switch databases: \connect database_name See the manual about psql.


This lists databases: SELECT datname FROM pg_database WHERE datistemplate = false; This lists tables in the current database SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;


\l is also shorthand for \list. There are quite a few slash commands, which you can list in psql by using \?.


In Postgresql these terminal commands list the databases available el@defiant$ /bin/psql -h localhost --username=pgadmin --list Or the command stated more simply: psql -U pgadmin -l Those commands print this on the terminal: List of databases Name | Owner | Encoding | Collate | Ctype | Access ...


Actually I was a bit underwhelmed with VS2010, to be honest. I think an old-school create table script and files for stored procedures are easier to work with. If you need schema management then you can get Redgate SQL Compare Pro for a few hundred dollars. If you really need a database modelling tool then Powerdesigner or even Erwin does a much better ...


From pg_Admin you can simply run the following on your current database and it will get all the tables for the specified schema: SELECT * FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema = 'public' ORDER BY table_type, table_name This will get you a list of all the permanent tables (generally the tables you're ...


I've been toying with how to structure an answer to this question since it was originally posted. This is difficult as the case for VS2010 isn't about describing the features and benefits of the tool. This is about convincing the reader to make a fundamental shift in their approach to database development. Not easy. There are answers to this question from ...


pgAdmin and psql, those are the tools I use. A PHP-script isn't very usefull for database management, too slow and many problems with transactions: What to do when something goes wrong? Commit or rollback? This makes tools like phpmyadmin and phpPgAdmin pretty useless, when the script is done, the database connection will be closed. There is nothing to ...


To gain more info on database and table list, You can do : \l+ to list databases List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description ------------+----------+----------+-------------+-----...


I started using NORMA (link fixed Oct 2011) which is useful to capture the relationships and constraints in plain English. See Object Role Modelling too. This will generate XSDs and SQL scripts. I hope never to see an ERD ever again...


MySQL has never come up with Query Profiling. Now that MySQL is being grandfathered by Oracle, I know this will continue to be the case. Yet, all hope is not lost. Since 2007, Percona has come up with some absolutely marvelous tools for everything a Developer and DBA would want, including Query Profiling. Percona's first set of tools, known as MAATKIT, ...


The best tool (if you can find it) is DataFactory. (Sadly out of print). I've generated absolutely delightful (and quite authentic-looking) datasets from it. is... acceptable, but doesn't scale very well. DataGenerator is something to keep an eye on. And while DTM Data Generator is clunky and a poor substitute for DataFactory, it exists ...


but for example no "arrow-up" key for the previous history entry is available. You're talking about sqlplusw the "GUI" tool - the oldschool sqlplus does support arrow-up-bring-previous-statements feature. What is a good replacement / extension for sqlplus Oracle's SQL Developer, a free GUI-based tool, is pretty neat. If you're a vim addict, there'...


It is possible that you have inserted the tables into a schema that is not in your search path, or the default, ie, public and so the tables will not show up using \dt. If you use a schema called, say, data, you can fix this by running, alter database <databasename> set search_path=data, public; Exit and reenter psql and now \dt will show you the ...


Did some googling around and here are some software that may interest you: SQL Job Vis (this seems the most popular, according to some forum and blog posts) SQL Job Manager Query Currently Running SQL Server Agent Jobs


SQL Server Management Studio that comes with SQL Server? If you need to run on non-Windows, then look at SQuireeL


A very easy tweak is to add rlwrap.


I have been working with Pentaho for about a year now. Pentaho is a full Open Source suite for Business Intelligence. It's strenght is that it relies on independently managed project : Pentaho Data Integration (Kettle) ->ETL Pentaho Report Designer (PRD) -> Report designer Mondrian -> R-OLAP cube and much more.. You can use them as a whole (Pentaho ...


There are several options in the PostgreSQL world, most of them are listed in the PostgreSQL wiki: The next version of pgAdmin will include a ER designer as well as far as I know. PowerArchitect works with PostgreSQL, though in the free version it is somewhat limited. In general it does not support ...


RedGate has a tool similar to what you're looking for, but it's destination is intended to be MS SQL Server. You might also check out the following article:


More for ER than for prototyping (never heard it in the context of databases): If you are on MySQL, try MySQL Workbench. Although it generates MySQL specific code, small adjustments are easily made. For PostgreSQL, there is a nice list in their wiki, PGDesigner lookes very capable. Furthermore, there will be a Designer in future versions of pgAdmin.


On recent versions you can see a timer in the "Task Progress" view (View->Task Progress). Annoyingly it resets to zero the moment the task finishes! :


A list of web replacements is available here: And this question was asked before in Stackoverflow as well: In my opinion, a alternative phpmyadmin should not just look good, but must at all cost keep up with ...


Each site I've consulted with that had Oracle swore by Toad as an interface for queries. Not the DBAdmins, but mostly the developers.


I think you're not understanding what is meant by datawarehouse. It's not a tool. Or an application. Or a database. It doesn't mean "big database". You said, we worked with MS Business Intelligence and MSSQL as Data Warehouse storage. MSSQL wasn't just the storage for the DWH, it is the DWH. A datawarehouse is a database which is specifically ...


I tried to use the VS tool yesterday with my production SQL 2000 instance, comparing to my dev 2008 instance, and it refused to work with anything prior to SQL 2005. Red Gate definitely does not have such a restriction. It even works reasonably well (not 100%) with another database we have that runs in 6.5 Compatibility Mode.


If you want to compare data in two different database designs then you'd have to write hand coded SQL to compare data. What if a table has been split, or combined etc? What if you had datetime, now you have smalldatetime = data will be different ... There is no library of framework for checking data is the same in two disparate databases. Only you ...


Sounds like my Cassandra Cluster Admin is exactly what you want! Take a look at it here:


A similar question was asked on SO and my answer is still the same: I use the Community Edition of MySQL Workbench for creating pretty pictures of my schema - but I'd rather create the DDL that actually runs on my database by hand.


I use Visual Studio extensively (well, BIDS) for SSRS report design, and SSIS packages. I couldn't do either very well, if at all, in Management Studio. Visual Studio is a much more complete and integrated development environment, and it hooks into Source Control systems much better too. And that's all reflected in the price!

Only top voted, non community-wiki answers of a minimum length are eligible