wynalazkowo - eksperymenty małe i duże

PostgreSQL – informacje o bazie

PostgreSQL – informacje o bazie

1. list of table indexes:SELECTtablename,indexname,indexdefFROMpg_indexesWHEREschemaname = ‚public’ \d table_name 2. DB & tables related \q: Quit/Exit \c __database__: Connect to a database \d __table__: Show table definition including triggers \d+ __table__: More detailed table definition including description and physical disk size \l: List databases \dy: List events \df: List functions \di: List indexes \dn: ListWięcej oPostgreSQL – informacje o bazie[…]

Oracle – errors

Oracle – errors

ORA-00001: unique constraint violated The ORA-00001 message is triggered when a unique constraint has been violated. Essentially the user causes the error when trying to execute an INSERT or UPDATE statement that has generated a duplicate value in a restricted field. The error can commonly be found when a program attempts to insert a duplicateWięcej oOracle – errors[…]

Postgresql – tips and tricks

Postgresql – tips and tricks

1) Connect to PostgreSQL database The following command connects to a database under a specific user. After pressing Enter PostgreSQL will ask for the password of the user. 1 psql -d database -U  user -W For example, to connect to dvdrental database under postgres user, you use the following command: 1 2 3 C:\Program Files\PostgreSQL\9.5\bin>psql -d dvdrental -U postgres -W Password for user postgres:Więcej oPostgresql – tips and tricks[…]

MSSQL Server – fundamentals

MSSQL Server – fundamentals

SQL Server Backup Types DB migration Restore DB from backup Clone/Copy DB https://blog.codeinside.eu/2018/07/31/easy-way-to-copy-a-sql-database-with-ssms/ ODBC – how to set up it https://www.techwalla.com/articles/how-to-create-and-setup-an-odbc-database-connection