Tag Info

Hot answers tagged

276

Please note the following commands: \list lists all databases \dt lists 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). See the manual about psql.


66

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;


33

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


24

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 ...


24

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 ...


15

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 ...


14

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 ...


12

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. Generatedata.com 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 ...


12

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...


12

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


11

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, ...


10

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 ...


10

There are several options in the PostgreSQL world, most of them are listed in the PostgreSQL wiki: http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools 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 ...


9

RedGate has a tool similar to what you're looking for, but it's destination is intended to be MS SQL Server. http://www.red-gate.com/products/sql-development/sql-data-generator You might also check out the following article: http://www.sqlservercentral.com/articles/Advanced+Querying/jointestdata/197/


8

A very easy tweak is to add rlwrap.


7

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 ...


7

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 ...


7

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.


7

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, ...


6

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 ...


6

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!


6

To be honest, my vote goes straight to SQL Server Management Studio for database design, development, and (obviously) administration. It is just easier to type out: create table newTable ( someId int identity(1, 1) not null primary key clustered, ...... you get the idea ) Then click in all the right places. SSMS is a great layout and an ...


6

VS may appear great if you don't know SSMS or have used 3rd party tools. The gaps in VS stand out if you use Red Gate tools for schema comparison etc. And the free SSMS plug-ins too. The source control bits is misleading: what is in the production database is your reference copy. Not what the developer is using. See ...


6

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) http://www.sqlsoft.co.uk/sqljobvis.php SQL Job Manager http://www.idera.com/Free-Tools/SQL-job-manager/ Query Currently Running SQL Server Agent Jobs ...


5

SQL Tools is an alternative I have tried. It didn't suit my needs, but it might yours. SQL Tools++ is built on SQL Tools.


5

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


5

A list of web replacements is available here: http://www.webdesigneronline.co.uk/10-great-alternatives-to-phpmyadmin And this question was asked before in Stackoverflow as well: http://stackoverflow.com/questions/1324972/ajax-phpmyadmin-alternative In my opinion, a alternative phpmyadmin should not just look good, but must at all cost keep up with ...


5

It's been a while since I used Red Gate, but the VS2010 has it matched from what I remember, with options to include or exclude by object types, and generate scripts to match the two schemas; the VS tools takes a while to run, I remember the Redgate to be pretty quick.


5

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.


5

You will need to grant access on a user@hostname basis, not just the user alone. So you will have to grant access to 'sequel_pro'@'your_domain_name' to database_name.*. Click here for a sample script.



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