SELECT pg_attribute.attname, format_type(pg_attribute.atttypid, pg_attribute.atttypmod) FROM pg_index, pg_class, pg_attribute, pg_namespace WHERE pg_class.oid = 'my_table_name'::regclass AND indrelid = pg_class.oid AND nspname = 'my_schema_name' AND pg_class.relnamespace = pg_namespace.oid ... Read more
How to generate a CREATE TABLE statement for a given table in SQLite
select sql from sqlite_master where type='table' and tbl_name='country' See also: How to generate a CREATE TABLE statement for a given table in SQL Server How to generate a CREATE TABLE statement for a given table in Oracle How to generate a CREATE TABLE statement for a given table in ... Read more
How to get column names from SQLite table
PRAGMA table_info(table_name); see also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Oracle table How to get column names from Mysql table How to get column names from PostgreSQL table Some SQLite tools you can try: ... Read more
How to get column names from PostgreSQL table
select column_name from information_schema.columns where table_name='my_table_name' see also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Oracle table How to get column names from Mysql table How to get column names from SQLite ... Read more
Export data from SQL Server query to SQL file
Want to export data from SQL Server query to SQL file? Using SqlToTxt, you can export data from SQL Server query to Sql file easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Export data from SQL Server query to Sql file Click “Export From ... Read more
About DB2 error “CLI0106E Connection is closed. SQLSTATE=08003”
Sometimes, you meet this error “”CLI0106E Connection is closed. SQLSTATE=08003” when you run DB2 tools. This error would be due to “The connection specified by the connection handle is no longer active.” You can add the following to your db2cli.ini file and restart the ... Read more
Batch export data from SQL Server tables to HTML files
Want to batch export data from SQL Server tables to HTML files? Using SqlToTxt, you can batch export data from SQL Server tables to Html files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Html files Click ... Read more
Batch export data from SQL Server tables to JSON files
Want to batch export data from SQL Server tables to JSON files? Using SqlToTxt, you can batch export data from SQL Server tables to Json files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Json files Click ... Read more
Batch export data from SQL Server tables to XML files
Want to batch export data from SQL Server tables to XML files? Using SqlToTxt, you can batch export data from SQL Server tables to Xml files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Xml files Click ... Read more
Batch export data from SQL Server tables to TSV files
Want to batch export data from SQL Server tables to TSV files? Using SqlToTxt, you can batch export data from SQL Server tables to Tsv files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Tsv files Click ... Read more