to get list of columns on certain table use this command:
select column_name, data_type from INFORMATION_SCHEMA.COLUMNS where table_name = ‘table’;
to get list of columns on certain table use this command:
select column_name, data_type from INFORMATION_SCHEMA.COLUMNS where table_name = ‘table’;
for version >= 8.4.0:
pg_dump –column-inserts –data-only –table=<table> <database>
for version < 8.4.0:
pg_dump -D -t <table> <database>
source:
We usually use DESCRIBE command in MySQL to display table structure, in PostgreSQL we use this command:
SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = ‘table’;
source:
http://stackoverflow.com/questions/109325/postgresql-describe-table
on my.cnf:
[mysqld]
innodb_file_per_table